We are using old version of windows server and ssms. We trying to upgrade or migrate our database from old version to new.\

Can anyone guide me what is the step to do so?

Here i'm giving you info what we are using right now .

• We are using Server 2003r2 - Standard X64 Edition service pack 2
• We are using SSMS as following version
• SQL Server 2005 - 9.00.5324.00 (X64) 
  Aug 24 2012 18:28:47 
  Copyright (c) 1988-2005 Corporation
  Standard Edition (64-bit) on NT 5.2 (Build 3790: Service Pack 2)

Our planning to upgrade on following configuration.

• Windows SQL Server 2008 r2 standard service pack 1 with intel(r) Xeon(r) CPU E5-2643 0@ 3.30GHZ, 32 GB Ram and 64 bit operating system.
• This is our Management studio.
• Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
• May 14 2014 18:34:29 
• Copyright (c) Microsoft Corporation
• Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Please let me know..Thanks

 

Documents supported upgrade paths to SQL Server 2012.

Supported Version and Edition Upgrades

Describes Upgrade Advisor, a tool that analyzes instances of SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 to identify known upgrade issues.

Use Upgrade Advisor to Prepare for Upgrades

Introduces the Distributed Replay Utility and describes how you can use it to prepare for an upgrade of SQL Server.

Use the Distributed Replay Utility to Prepare for Upgrades

Provides links to procedural topics for upgrading to SQL Server 2012.

Upgrade How-to Topics

In General guide for upgrading the database.

1. Run upgrade adviser on the databases for the instance you want to upgrade.
2. If any issues are found, talk to your dev team/ Vendor for fixing the same.
3. If issues are fixed proceed with the actual upgrade. -- Do check for the other dependencies on the database which might affect the functionality if the instance gets upgraded or something like that.
4. Get the downtime for the database.
5. Create the latest full backup of the database -- any other strategy will also work, just make sure you can recover the database.
6. Take a clone of the server if it's a virtual server to roll back any changes.
7. Run the upgrade on the sql 2005 instance from the 2012 set up. -- do check the pre-requirements for upgrade to sql 2012.
8. If everything is fine then you have an upgraded instance.
9. Also check the compatibility of the databases.

10.  If all is fine then congrats you have upgraded your sql server instance

You must refer to the SQL Server 2012 Upgrade Technical Guide

The deprecated features from SQL Server 2005 are at - 

http://technet.microsoft.com/en-us/library/ms143729(v=sql.90).aspx

Must read a similar tread: Migration of SQL Server 2005 to 2012

Hi,

Its good you are migrating from 2005 to 2012.

What migration strategy you are planning

1. In place upgrade

2. Side by side upgrade

Please dont forget to run 2012 upgrade advisor and see if it is pointing any breaking changes. You must also read breaking changes in 2012

For upgrade Please read SQL Server 2012 Upgrade guide from Microsof

As on supported version and edition upgrades documents. You can upgrade from SQL Server 2005 service pack 4 but, we have SQL Server 2005 Service pack 2, So is there anyway I can by pass this situation? 

• Edited by Danny2426 13 hours 47 minutes ago

As on supported version and edition upgrades documents. You can upgrade from SQL Server 2005 service pack 4 but, we have SQL Server 2005 Service pack 2, So is there anyway I can by pass this situation? 

To obtain SQL Server 2005 SP4, visit the following Microsoft Web site: Microsoft SQL Server 2005 Service Pack 4 RTM

Hello Rachit,

Can I Ask you one more question?

In SQL Server 2005 Database compatibility level is 90 but if change in sql server 2012 to 110  than will I get any error?

As on supported version and edition upgrades documents. You can upgrade from SQL Server 2005 service pack 4 but, we have SQL Server 2005 Service pack 2, So is there anyway I can by pass this situation? 

• Edited by Danny2426 Friday, August 21, 2015 5:19 PM

Hello Rachit,

Can I Ask you one more question?

In SQL Server 2005 Database compatibility level is 90 but if change in sql server 2012 to 110  than will I get any error?

No you wont get any errors, you can set the database compatibility level of the upgraded databases to 110. 

If you find that you cannot support certain behaviour changes immediately, you have the option of modifying the database compatibility level to limit or allow certain functionality depending on the level you select. During the upgrade process to SQL Server 2012, a database will retain its existing compatibility level if the database compatibility level is greater than or equal to 90. Otherwise, Setup will automatically set the compatibility level to 90.

Before you change the compatibility level of an upgraded database to 110, you must assess how the change might affect your applications. For specific compatibility-level guidance, see ALTER DATABASE Compatibility Level (Transact-SQL) (http://msdn.microsoft.com/enus/library/bb510680(v=sql.110).aspx).

Please open a new thread for new questions and mark appropriate replies as answers. It will help others to track. 

Hello Rachit,

Can I Ask you one more question?

In SQL Server 2005 Database compatibility level is 90 but if change in sql server 2012 to 110  than will I get any error?

No Danny you wont get any error message as a fact you should change compatibility level after migration unless you have some other requirement

Rachit,

Can you please stop proposing your own answer this is not a correct practice on forum.