How to import SQL 2000 database to SQL 2014

What is the best method to import database from an old Microsoft SQL version 2000 to our SQL 2014
Who is Participating?
Nakul VachhrajaniConnect With a Mentor Technical Architect, Capgemini IndiaCommented:
What problem? Can you please share your error message/screenshots, etc?

Please note that SQL 2000 to SQL 2014 is not a direct upgrade:
1. You need to first restore the SQL 2000 database on SQL Server 2008
2. Change the compatibility level of the database to 100
3. Take a backup of this SQL 2008 database
4. Restore on a SQL 2014 instance

Once the restore is complete, you can then make the necessary T-SQL changes to support SQL 2014 and finally update statistics on all the tables.
Russ SuterCommented:
Perform a full backup of the existing database. Then create a new empty database on the new server and perform a Recovery with OVERWRITE on the new database using the old .bak file. I do this all the time.
rayluvsAuthor Commented:
"Recovery"?  or Restore?
rayluvsAuthor Commented:
(If it's Restore we have done exactly that: we backup from sql0000, create that DB in swl2014 then restore with overwrite and still same problem)
rayluvsAuthor Commented:
Oh!!! Now that one we didn't do, the SQL 2008 & compatibility stuff!!   Ok, let's give it a try!!
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.