Red Gate forums :: View topic - SQL Azure
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 7
SQL Packager 7 forum

SQL Azure

Search in SQL Packager 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rene1983



Joined: 11 Jun 2012
Posts: 4

PostPosted: Tue Sep 03, 2013 3:40 pm    Post subject: SQL Azure Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Mon Sep 09, 2013 2:47 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
rene1983



Joined: 11 Jun 2012
Posts: 4

PostPosted: Mon Sep 09, 2013 3:04 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Tue Sep 10, 2013 12:00 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Thu Sep 12, 2013 1:43 pm    Post subject: Reply with quote

Sorry, the bug reference is SPA-635. My mistake.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group