Forum Discussion
Updating a sql 2019 database from a sql 2000 database
Good morning I have a local sql server 2000 database with an old application, and I would like to make a copy of this database on sql server 2019 which is online with an ip address on a hosting, and...
For updating SQL server 2000 to SQL server 2019, you can follow various steps.
1) First set up SQL server 2019 and access the SQL server instantly.
2)Take a back from server 2000 and transfer it from the machine to SQL server 2019. Also, restore backup on SQL server 2019 at proper destination database name.
Just need to have a specific requirements such as
a) SQL provides various replication issues to keep 2 databases synchronized.
b) Set up log shipping as it takes backup periodically from SQL Server 2000 and restore to SQL server 2019.
c) Modifying old application with specific code and track changes in SQL server 2000 and copy to SQL server 2019.
Using above all steps will you update your SQL Server 2000 database to SQL Server 2019
1) First set up SQL server 2019 and access the SQL server instantly.
2)Take a back from server 2000 and transfer it from the machine to SQL server 2019. Also, restore backup on SQL server 2019 at proper destination database name.
Just need to have a specific requirements such as
a) SQL provides various replication issues to keep 2 databases synchronized.
b) Set up log shipping as it takes backup periodically from SQL Server 2000 and restore to SQL server 2019.
c) Modifying old application with specific code and track changes in SQL server 2000 and copy to SQL server 2019.
Using above all steps will you update your SQL Server 2000 database to SQL Server 2019