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

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Support for SQL Azure?

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
ehuna



Joined: 06 Nov 2006
Posts: 11

PostPosted: Fri Aug 21, 2009 9:52 pm    Post subject: Support for SQL Azure? Reply with quote

The SQL Azure CTP has been released; I received an invitation token and I've been following the labs in the training kit and playing with it.

Right now, there's a lot of manual steps to clean up SQL Scripts generated from an on-premise SQL Server 2008 so they work on a SQL Azure database.

Are there any plans for SQL Compare to work with SQL Azure? If you act fast, you could have a killer app until Microsoft cleans up SQL Server Management Studio. I'll give you my left arm if you have it ready soon. Wink

Here are some links:

The announcement that SQL Azure CTP is available
http://blogs.msdn.com/ssds/archive/2009/08/18/9874133.aspx

Page where you can register for the CTP
http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx

Windows Azure Platform Training Kit
(includes a bunch of labs related to SQL Azure)
http://www.microsoft.com/downloads/details.aspx?FamilyID=413E88F8-5966-4A83-B309-53B7B77EDF78&displaylang=en

Note: I don't work for Microsoft - I've been a long time user of SQL Compare and I'd love for it to work between my development on-premise SQL Server 2008 and my future Staging/Production SQL Azure databases.
Back to top
View user's profile Send private message
Nick



Joined: 30 Nov 2005
Posts: 9

PostPosted: Mon Aug 24, 2009 11:30 am    Post subject: Reply with quote

Thanks for your question, ehuna.
Currently we don't have any plans to support SQL Azure. This may change in the future depending on the success of SQL Azure.

The good news is there's no need to lose your left arm. I'll let you know if we ever require a finger as a down-payment.
Back to top
View user's profile Send private message
mbaladi



Joined: 28 Aug 2009
Posts: 1

PostPosted: Fri Aug 28, 2009 1:46 pm    Post subject: SQL Azure Reply with quote

To bad, you could have had my left arm as well.

I'm still on v5 of SQL/Data compare and I love it. Today i downloaded v8 to see if worked with Azure, but the same problem as v5. I would have upgraded TODAY if v8 had supported Azure.

I think the effort for you guys to make it work with Azure would be minimal since it's just a limited SQL server available over TDS and that you would need to make the first fix anyway soon...

Seems like SQL Compare requires sp_dbcmptlevel an in books online it says:
This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use ALTER DATABASE Compatibility Level instead.
_________________
/Michel
Back to top
View user's profile Send private message
Nick



Joined: 30 Nov 2005
Posts: 9

PostPosted: Fri Aug 28, 2009 4:39 pm    Post subject: Reply with quote

mbaladi

At the moment we don't have any firm plans, although we will keep an eye on the growth of SQL Azure and act accordingly.

Regards

Nick Wood
_________________
Part of the team
Red Gate Software
Back to top
View user's profile Send private message
ehuna



Joined: 06 Nov 2006
Posts: 11

PostPosted: Fri Aug 28, 2009 4:57 pm    Post subject: Reply with quote

Nick,

I understand you need to prioritize features depending on the popularity of the platform or device your code is targeting. That's one of the reasons so many developers are writing iPhone apps.

But if you had to bet on a platform related to SQL Server, I think SQL Azure is a safe bet. Microsoft has invested over 2 billion dollars already on Azure and it's creating 5 data centers in the US that are over 500,000 square feet each. There's a similar data center being built in Dublin, Ireland as well.

Only the SQL Azure CTP is available and hundreds of thousands of invitation tokens have been sent. Check out the SQL Azure CTP forums and you'll see dozens of threads each day - and the CTP was released less than a week ago!

As mbaladi mentioned - SQL Azure works on port 1433 - it's TDS! That should minimize your efforts to make a version of SQL Compare that works with SQL Azure. Check out for example my two blog posts on scripts for SQL Azure:

Cleaning up scripts for SQL Azure
http://blog.ehuna.org/2009/08/cleaning_up_scripts_for_sql_az.html

and

Windows PowerShell commands to clean up scripts for SQL Azure
http://blog.ehuna.org/2009/08/windows_powershell_commands_to.html

I also opened a thread on the SQL Azure forums to share cleaning tips with other developers:

http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/2e72f8a8-7e25-4149-98e6-2fd6c1506159

I spent 20 minutes and created the above PowerShell scripts that handle 90$% of my issues when cleaning up the generated scripts from SSMS for SQL Azure. I'm sure it wouldn't take you that long to come up with an integrated solution in SQL Compare.

Of course I can't make you fix SQL Compare so it works with SQL Azure - but even today you would make a lot of money from folks upgrading their old versions of SQL Compare to streamline their SQL Azure development. Seems line a no brainer to me.
Back to top
View user's profile Send private message
sirana



Joined: 11 Nov 2009
Posts: 1

PostPosted: Wed Nov 11, 2009 12:16 am    Post subject: Add my vote Reply with quote

I'm actively developing on SQL Azure now, and am current on my Red Gate maintenance for now. But support for SQL Azure will be the single metric I evaluate when it comes time for renewal. I really don't need any new features or whiz-bang items for regular SQL, since I use so little of the product as it exists today.

I only have one license, so who cares, right? But this is not just some random technology that's coming out of left field. Unless I'm completely wrong, I'd guess that MS SQL is the most popular platform for your customers so far, and this is just another variant of that. You have to have a response for this that's better than "we'll see in a year or two whether it makes a market".

Chris
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Wed Nov 11, 2009 1:50 am    Post subject: Reply with quote

Hi Chris,

Thanks for your query. We're currently in the process of assessing the work required to support Azure. Of course even when we have this data we won't know for sure when will be the right time to implement Azure support, but we should hopefully have a better estimate for you. We'll post to this thread once we have more information. Thanks for your patience.

Regards,

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
wmild



Joined: 03 Oct 2008
Posts: 13

PostPosted: Tue Nov 17, 2009 11:18 pm    Post subject: me too! Reply with quote

Just want to put my vote in for SQL Azure support. Ditto to everything the others said. You guys have an awesome tool and SQL Azure support would be a slam dunk.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Thu Jan 28, 2010 12:38 am    Post subject: Reply with quote

We have an early access build of SQL Compare that works with Azure. If you're interested in trying this out please complete the form at www.red-gate.com/Azure. We're very interested to know how you're getting on with Azure, what works for you and what doesn't work so well.

Thanks!

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
ehuna



Joined: 06 Nov 2006
Posts: 11

PostPosted: Thu Jan 28, 2010 1:35 am    Post subject: Reply with quote

David, that's great news! Thank you for listening to your customers and following up with this early access build of SQL Compare with support for SQL Azure.

As more and more developers find out about Windows Azure and host their data on SQL Azure I'm convinced this will pay off for Red Gate. Thanks!
Back to top
View user's profile Send private message
RMD



Joined: 29 Jan 2009
Posts: 13

PostPosted: Tue Apr 20, 2010 6:15 pm    Post subject: Reply with quote

The Azure compatible releases expire in a couple of days. Any word on an update?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Wed Apr 21, 2010 11:05 am    Post subject: Reply with quote

[edit] SQL Azure builds are now part of the main SQL Compare 9 and SQL Data Compare 9 products, and can be downloaded from the Red Gate website. If you have any trouble, please email support@red-gate.com

Regards,

David Atkinson
Product Manager
Red Gate Software


Last edited by David Atkinson on Wed Apr 27, 2011 12:47 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
jkrishnaswamy@comcast.net



Joined: 05 May 2010
Posts: 1
Location: Plainsboro, NJ

PostPosted: Wed May 05, 2010 11:57 am    Post subject: SQL Azure support Reply with quote

Besides SQL Compare what other products are there supporting SQL Azure?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Wed May 05, 2010 12:33 pm    Post subject: Reply with quote

SQL Data Compare is the only other tool that is SQL Azure aware. Which other tools do you feel SQL Azure would benefit from, and why?

David
Back to top
View user's profile Send private message Send e-mail
mmooney



Joined: 19 Jan 2011
Posts: 1

PostPosted: Wed Jan 19, 2011 8:25 pm    Post subject: Red Gate Azure Backup Example Reply with quote

Hey guys,

Thanks for adding Azure support, it saved our tail when we switched to Azure, because we were able to use SQL Compare and SQL Data Compare to put together a pretty workable offsite backup solution for our Azure databases.

I wrote up the details here, hopefully it will help out some more people facing the same issue: http://mooneyblog.mmdbsolutions.com/index.php/2011/01/11/simple-database-backups-with-sql-azure/

Thanks again, keep up the good work
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