locked
Is SQL azure and SQL management studio the same? RRS feed

  • Question

  • I had a database in SQL management studio and I'm transferring it to SQL azure but there are some errors. Can I know if there is any SQL syntax differences between these two? 
    Friday, November 4, 2011 5:38 AM

Answers

All replies

  • Hi,

    there are a few differences, but I think the SQL Azure Migration Wizard from Codeplex should help you - http://sqlazuremw.codeplex.com/


    Best Regards. Please Mark Answered, If my solution solves your problem.
    • Proposed as answer by Olaf HelperMVP Friday, November 4, 2011 4:08 PM
    Friday, November 4, 2011 9:57 AM
  • Unleashed,

     

    I have found the two utilities are not exactly the same. Prior to recent SQL Azure upgrade, using SQL Enterprise manager seemed to provide an easier way to view/edit data and objects. After the recent upgrade, however, I would say the web-based utility is much faster at modifying objects. One of the key differences I have found is that SQL Ent. Mgr doesn’t seem to allow scripting of any objects. This is a very common practice in migrating / manipulating data and is not an option in either environment.

     

    With both utilities, you should be able to execute commands against your database. That ability alone is usually enough for any admin to get by with.

     

    -Bryan

    Friday, November 4, 2011 10:08 PM
  • Thank you. Is there any converter from SQL management studio to SQL azure?
    Saturday, November 5, 2011 12:31 PM
  • If i understand you correctly, you are trying to migrate your SQL server DB to SQL Azure, Then as Horizon_net mentioned you could check out SQL Azure migration wizard. But if you run into errors and to understand what's happening - I would recommend you:

    1. General Guidelines and Limitations SQL Azure (BOL)

    2. SQL Azure vs SQL server (Technet Wiki)

     

    And you could also consider posting your errors here and get suggestions from SQL Azure community on how to solve it. 


    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )
    Saturday, November 5, 2011 9:05 PM
  • Hi,

    I hope your question is to use the SQL DB on to SQL Azure cloud. You can use the migrating assitance to do that. Check the below article

    http://beyondrelational.com/blogs/vishalpawar/archive/2011/05/26/ssma-sql-server-migration-assistant.aspx


    Thanks Karthikeyan Anbarasan http://f5debug.net/
    Tuesday, November 22, 2011 2:05 PM