Apr 28 2023 01:00 AM
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 will be updated automatically and instantly by this old database .
Please suggest me a solution.
Have a good day
May 01 2023 11:44 PM
@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.
May 02 2023 01:26 AM
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.
May 16 2023 11:01 PM