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...
jassem40 , there is no direct way to upgrade version 2000 to 2019, you can only upgrade over max. 3 versions, mean 2000 => 2008, 2008 => 2014, 2014 => 2019.
Or you script everything = objects and data out to recreate and new database.
Hi
without upgrade the server, I don't need the other objects(stored procedure, trigger, etc.)
I use this method Data Import Wizard, but what I want if there is a solution so that my 10 tables updated on sql 2000 will also transfer the data automatically to 2019, I want to transfer only the data from 10 tables to the new 2019 server to use them for creating dashboards with power bi.
