SQL Azure

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings

SQL Azure

Postby rene1983 » Tue Sep 03, 2013 3:40 pm

Is it possible to use Packager 7 to create a SQL Azure database?

The release notes state "SPA-607 - It is now possible to run an upgrade .EXE for SQL Server 2012 databases against a SQL Azure database".

Thanks,

Rene.
rene1983
 
Posts: 5
Joined: Mon Jun 11, 2012 12:03 am

Postby Brian Donahue » Mon Sep 09, 2013 2:47 pm

Hello again,

I think you have possibly logged at least one duplicate call with support about this, if this is the same issue you emailed us about, it's probably sufficient to not use the /makedatabase switch with Azure, seeing as you have to use Microsoft's Azure management interface to actually create a database.

Otherwise it tries to check your permissions on the server and you get a "Built-in function 'PERMISSIONS' is not supported in this version of SQL Server" message.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby rene1983 » Mon Sep 09, 2013 3:04 pm

I don't understand why I can't CREATE Azure database using SQL Packager but I can create an Azure database using SQL Compare.

Is this a planned feature? It would be really helpful!

Yes it's the same issue I emailed to you.

Thanks,

Rene.
rene1983
 
Posts: 5
Joined: Mon Jun 11, 2012 12:03 am

Postby Brian Donahue » Tue Sep 10, 2013 12:00 pm

I've logged development issue SPA-634 about this.

To confirm, though, the original bug that you referenced says SQL Packager produces upgrade packages for Azure - in my mind that says you will be running against an existing database. So maybe there was a conscious decision by Red Gate not to support database creation. I am trying to find out.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Sep 12, 2013 1:43 pm

Sorry, the bug reference is SPA-635. My mistake.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager 7

Who is online

Users browsing this forum: No registered users and 0 guests