Updating a sql 2019 database from a sql 2000 database

[jassem40]

Good morning
I want to use power bi, to have dashboards with automatically updated informations from the server.
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

[foodd]

@jassem40 , if the legacy Application has been decommisioned, it would seem to suggest that a one time migration of the data from 2000 to 2019 would make sense.  If the legacy Application is still in use, you could explore a Power Automate or similar solution.     Consider bringing your question to the Azure Data Community, where you’ll find user groups and resources related to SQL Server, Azure Data.  These resources are a seperate Community from the Fabric Community where this post resides.

On the other hand, It also seems you haven't received any feedback or updates regarding your question or a status update. If you've already resolved your issue, could you please share the solution with the forum so that others may benefit? Also, if possible, please mark that post as a solution. Thank you!

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.