Home Button  Buy Button 

Topic:   MiniMrp on an Azure SQL Server

By: Cas MeijerPosted on: Dec 21 2021 at 04:04:07 AM
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: GuestPosted 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: GuestPosted 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.

Topic:- MiniMrp on an Azure SQL Server

Enter the numbers.

Your name here is optional