Deploy SQL 2012 DB to Azure

I am having a real issue deploying a DB from SQL 2012 to Azure SQL. Simple and sample DBs, don't seem to be any issue. My DBs are complex with SP's, views, Functions etc.  Should I be able to take any SQL 2012 DB and push to Azure or is Azure SQL watered down?
LVL 3
egarrisonCEO / CTOAsked:
Who is Participating?
 
egarrisonConnect With a Mentor CEO / CTOAuthor Commented:
I did get someone on the phone with Microsoft. Sounds like they want me to VM with the SQL image, not use the Azure DB.  I am not sure that is going to be as cost effective.
0
 
David Johnson, CD, MVPOwnerCommented:
0
 
egarrisonCEO / CTOAuthor Commented:
Yes.  It looks like it is creating most of my structure. I have 1900 SP's, Views, Tables, triggers (etc).

I get errors like these

-- Removed 'ROW GUID COLUMN' because it is not supported in this version of SQL Server.
 
--> Error #: 40512 -- Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server.

Should the wizard also move the data?  It is not moving any rows.
0
 
ZberteocCommented:
Maybe this would be usefull:

https://sqlazuremw.codeplex.com/
0
 
egarrisonCEO / CTOAuthor Commented:
There was not really a solution other than Azure is not a viable solution at the moment.
0
All Courses

From novice to tech pro — start learning today.