I am in the process of transferring a database from one Azure environment to another Azure environment. The old database must remain intact and I would like to do the deployment via a release pipeline in devops.
I created a new database project with visual studio and connected to the old database and then did a 'compare'. After this I pushed the new database to devops.
In the release pipeline I used the dacpac file generated in visual studio to set it up on the new database, it works fine. So i have the tables in the new db but without data.
I am now running into the fact that I also want to transfer the data (content) of the tables on the old database to the new, preferably via the classic release pipeline. Do you have any ideas how I can best do this and what the best practice is?
It's about 5 or so tables
Created bacpac with ssms Created dacpac with vs and pushed it into the new database
