migrate database from SQL SERVER 2000 to SQL SERVER 2019

[sann85_sql]

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?

[#2]

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

[#3]

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