Link to home
Start Free TrialLog in
Avatar of benc007
benc007Flag for United States of America

asked on

SQL Server 2000 to 2012 Database Upgrade Migration

I want to migrate SQL Server 2000 databases to SQL 2012.  I think I have to migrate to SQL 2008 first, so I manually migrated the database from SQL 2000 to 2008 and then to 2012, which is quite a tedious manual process.

If I migrate from SQL 2000 to 2008 then to 2012 now, and I have newer SQL 2000 database files (MDF/LDF and backup) later, is there a SQL script that can automatically migrate the newer databases then?  

How would I see if SQL 2000 stored procedures and functions are ok before / after upgrading?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of benc007

ASKER

Hi Vitor,

RE: What do you mean? You migrate the SQL Server 2000 database but it will keep being used so you need to somehow update the new database version with the changes made in the old one?

It's because I am doing a test database migration, after which the front end and middle tier code needs to be tested to see if everything works.


RE: How would I see if SQL 2000 stored procedures and functions are ok before / after upgrading? ... By testing them one by one.
Would SQL Server 2008 Upgrade Advisor help?  Would I use 2008 Upgrade Advisor and also 2012 Upgrade Advisor?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Recommendation to close this question by accepting the above comments as solution.