Concern about many error messages in migration from local DB to Azure SQL

This starts out technical, but turns into more an evaluation of difficulty vs capability.

I'm attempting to host an asp.net application on Azure. The app uses two SQL 2012 MDFs, "CTLS", and "DATA".    

I'm using SSMS to create a TSQL of the DATA.MDF, then processing that with the SQLMigrationWizard.   In the process the wizard shows many error messages, of the following types, followed by approximate quantity:


sp_fulltext is not supported in current version of Azure SQL Database (~2)
FULLTEXTSERVICEPROPERTY is not supported in current version of Azure SQL Database (1
ALTER DATABASE is not supported in current version of Azure SQL Database (~30)
sp_helpuser is not supported in current version of Azure SQL Database (1)

dbcc checkident is not supported in current version of Azure SQL Database (4)
DBCC SHRINKDATABASE is not supported in current version of Azure SQL Database (1)
sp_addextendedproperty is not supported in current version of Azure SQL Database (~40)

When I ran a similar process for the CTLS.MDF, I just deleted all the "hard" errors and then the uploaded completed successfully.

My concern is, what is the affect on the application of removing all these statements?  What are the chances the application might perform differently with these statements removed, meaning I would have to retest it in detail on Azure SQL?

My real issue here is that I'm a SQL newbie, and I'm stretched, and I'm not sure I can make this work for me.   I'm pretty sure I could figure it out eventually, however, I'm not sure I can do the TSQL editing accurately and consistently enough to feel secure about running demonstrations on it.  Migrating to Azure SQL may represent an obstacle that I can't really afford to take on.  So my eyes turn toward other hosting services that just use vanilla SQL Server 2012, where I might not have these issues.

Any guidance or thoughts on this would be appreciated.

Thanks!
LVL 2
codequestAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
as said by the messages, you are using features that are not supported by the Azure version of SQL.

If you want to keep all the features on par with what you are using today while still move to Azure, you will need to use a VM hosted in Azure in which you will install exactly the same SQL server you have today.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
codequestAuthor Commented:
Thanks for the input.  I appreciate that I'm asking a highly subjective question.   The problem is that I don't know enough about SQL to know whether those features are necessary or not.   Also, I'm afraid that if I start to remove some of them, I'll break my little demo app, which is otherwise running ok.

Your response helps me think about it.   It's lending weight to the view that I can't afford the risk (=time to fix) of opening up the whole SQL technology box.
0
codequestAuthor Commented:
This article

https://azure.microsoft.com/en-us/documentation/articles/data-management-azure-sql-database-and-sql-server-iaas/

contains this quote:

Important note: Currently, Azure SQL Database does not support all the features of SQL Server. For a detailed comparison information, see Azure SQL Database Guidelines and Limitations. Be aware of this when you want to move an existing database to Azure SQL Database as you might need some additional budget on database redesign.

Meaning, you need to have a certain level of competence in DB design, or you are going to have risks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.