• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1009
  • Last Modified:

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
0
rayluvs
Asked:
rayluvs
  • 3
1 Solution
 
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.
0
 
rayluvsAuthor Commented:
"Recovery"?  or Restore?
0
 
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)
0
 
Nakul VachhrajaniTechnical 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.
0
 
rayluvsAuthor Commented:
Oh!!! Now that one we didn't do, the SQL 2008 & compatibility stuff!!   Ok, let's give it a try!!
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now