migrate database from SQL SERVER 2000 to SQL SERVER 2019

Occasional Visitor

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?

 

 

 

1 Reply

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