@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.
