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

Migrating from SQL 2000 to SQL 2012

Is it possible to take a Microsoft SQL 2000 database on one server and migrate it to a completely different server that is running Microsoft SQL 2012 and use this database? We use it for our Intranet.

Any assistance offered would be greatly appreciated.
0
regsamp
Asked:
regsamp
  • 4
  • 4
1 Solution
 
Lee SavidgeCommented:
No, you can't do it directly.

http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx

In short, you need to upgrade to SQL 2005 latest service pack first, then upgrade to 2012.
0
 
regsampAuthor Commented:
So the existing database that is currently SQL 2000 and is our Intranet needs to be upgraded to SQL 2005 and then migrated over. Correct?
0
 
Lee SavidgeCommented:
Yes, that is correct.

Has the code in the intranet that makes SQL calls been upgraded to work with SQL 2005 and above?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
regsampAuthor Commented:
It has not. Does all that need to be updated as well?
0
 
Lee SavidgeCommented:
I don't know as I don't know what the code is like that calls into your current database. I wouldn't do this on your live system. Build a virtual machine copy of the intranet and then try upgrading in a test environment.

This is no small job and needs to be handled correctly.
0
 
regsampAuthor Commented:
We have been trying to contact the Programmer who did the coding but nothing so far. Exactly. This is quite a big job that we want to make sure it does not have tons of issues.
0
 
Lee SavidgeCommented:
Ok, well things like the database using deprecated datatypes:

http://dba.stackexchange.com/questions/15857/upgrade-process-from-sql-server-2000-to-sql-server-2012

SELECT  sys.objects.NAME AS [table_name] ,
        sys.columns.NAME AS [column_name] ,
        sys.types.NAME AS [data_type]
FROM    ( sys.columns
          INNER JOIN sys.objects ON sys.objects.object_id = sys.columns.object_id
        ) INNER JOIN sys.types ON sys.types.system_type_id = sys.columns.system_type_id
WHERE   sys.types.name IN ( 'text', 'ntext', 'image' )

Open in new window


More here on the migration path:
http://sqlmag.com/sql-server-2012/migrating-sql-server-2012

This link includes the supported edition and version upgrades here:
http://msdn.microsoft.com/en-us/library/ms143393.aspx

There may be SQL functions that have been used in the intranet code and/or stored procedures that are deprecated in the later version of SQL.
0
 
regsampAuthor Commented:
Thank you for those links and information. I will go through them.
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: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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