We are trying to move our MiniMrp installation from a local SQLServer version 14.0.2002.14 to an Azure database. But the DBTool seems to want to create the database by itself instead of using the (empty) existing and prepared one.
Creating databases in Azure from the master database does not quit e work the same.
Is there a way to make this work?
By: Guest
Posted on: Dec 21 2021 at 06:38:06 AM
DBTools needs to have DROP and CREATE permissions. You need to check with your azzure account to make sure that an external user account can drop and create a database
By: Guest
Posted on: Dec 29 2021 at 04:02:05 AM
Or, seeing as how you already have the database on a local SQL Server, maybe you could use the local SQL Server to make a backup and then use the azure sql server to restore that backup into azure.
I don't have azure but SQL Server does allow a backup from an old server to be restored into a new server. So from local to azure should also be possible. I would guess that is the most common way for people to migrate from local sqlserver anyway.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
