Forum Discussion
migrate database from SQL SERVER 2000 to SQL SERVER 2019
I have database created using SQL SERVER 2000.
Now I have a requirement to migrate existing database to SQL SERVER 2019.
Is there any way migrate database directly from SQL SERVER 2000 to SQL SERVER 2019?
Note: I saw some findings like SQL SERVER 2000 ->SQL SERVER 2008R2->SQLSEVER 2019 is possible
I need direct migration from SQL SERVER 2000 to SQL SEVER 2019?
Also any script level item is there for conversion?
I need direct migration from SQL SERVER 2000 to SQL SEVER 2019?
sann85_sql , that's absolutely impossible, no way.
You have to take several intermediate steps between, like 2000 => 2008 R2 => 2012 => 2019
See Supported version and edition upgrades (SQL Server 2019)
Olaf
- Hi
very simple you can use "import and export date "app in sql server 2000 export data from sql server 2000 and import to sqlser2019
