Update my database from mssql 2005 and 2008 to 2014 - doubts

Hello guys

I have some clients in mssql 2005 and 2008 , I want to update them to 2014 but I don't have the idea the impact with tables, functions ,views and store procedures.

Is there any place that I could get those information what changes are between them?

thanks
Alexandre
LVL 1
hidrauAsked:
Who is Participating?
 
Scott PletcherSenior DBACommented:
MS has a free utility, "Microsoft Data Migration Assistant", that will scan all the databases and tell you of any potential issues.

Just download it from their website for free, install it and run it.  It gives good details on issues and potential issues.  It has basic gui, with limited options, but does it core function very well.
0
 
hidrauAuthor Commented:
thanks a lot for this clue;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.