Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Migrating from SQL 2000 to SQL 2012

Posted on 2014-03-03
8
Medium Priority
?
381 Views
Last Modified: 2014-03-03
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
Comment
Question by:regsamp
  • 4
  • 4
8 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 2000 total points
ID: 39900191
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
 

Author Comment

by:regsamp
ID: 39900199
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
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39900207
Yes, that is correct.

Has the code in the intranet that makes SQL calls been upgraded to work with SQL 2005 and above?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:regsamp
ID: 39900213
It has not. Does all that need to be updated as well?
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39900218
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
 

Author Comment

by:regsamp
ID: 39900221
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
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39900224
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
 

Author Comment

by:regsamp
ID: 39900234
Thank you for those links and information. I will go through them.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The first step to building an amazing About page is to figure out what you want the page to say about your company. You then must grab the attention of the reader, boast a bit, tell a story and let others brag about you. With a little bit of thought…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question