I am using Microsoft Data Migration Assistant to migrate data from the local sql server to the staging azure sql, but for some reason there are discrepancies with the data (i.e., the data changes from the local sql server are not appearing on azure sql). How do you migrate sql server local to sql azure easily? Am I missing something here? Shouldn't Migration Assistant do this if it is successfully migrating?
Does this work with an existing database instance in azure, or will I have to delete the database in azure first? What is the workflow?
I am not sure why data migration assistant is not working to update the azure database using the local database's copy.
Also, what is the workflow when making and testing development changes - is a local database used for that purpose and then azure updated with the local database or is there another safe workflow to ensure data integrity and no losses?
Thanks! For option 2 "import to existing db", how do you do that importing in azure sql specifically to an older version of a db already there on azure?
Thanks. Then for content editors who make changes to the azure sql database, what do you suggest for developers when they're testing using an out-dated (for content) local sql db? How can the developers review the live db without causing changes to the live azure db, especially if they are updating the umbraco version for example?
Migrating sql database from local to azure sql
I am using Microsoft Data Migration Assistant to migrate data from the local sql server to the staging azure sql, but for some reason there are discrepancies with the data (i.e., the data changes from the local sql server are not appearing on azure sql). How do you migrate sql server local to sql azure easily? Am I missing something here? Shouldn't Migration Assistant do this if it is successfully migrating?
You have several ways the simple one is generate bacpac and import on azure database
Does this work with an existing database instance in azure, or will I have to delete the database in azure first? What is the workflow?
I am not sure why data migration assistant is not working to update the azure database using the local database's copy.
Also, what is the workflow when making and testing development changes - is a local database used for that purpose and then azure updated with the local database or is there another safe workflow to ensure data integrity and no losses?
You can do it in several ways to do it
Thanks! For option 2 "import to existing db", how do you do that importing in azure sql specifically to an older version of a db already there on azure?
if it empty db should import it as is
Thanks. Then for content editors who make changes to the azure sql database, what do you suggest for developers when they're testing using an out-dated (for content) local sql db? How can the developers review the live db without causing changes to the live azure db, especially if they are updating the umbraco version for example?
is working on a reply...