convert database from 2005 to sql 2012

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

convert database from 2005 to sql 2012

Author

Topic

emadseed
Starting Member

5 Posts

Posted - 2013-02-11 : 00:52:21

I need a help please,,

I've got a database created in sql 2005 and i want to attach it to sql 2012,

any ideas please ,,

thanks in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 00:59:13

just detach it from sql 2005 server and attach it to sql 2012 instance. Its backward compatible and should work fine in new instance. I hope your sql 2005 db is at 90 compatibilty level and doesnt have any changes which 2012 doesnt support

Make sure you read this before you proceed with attach

http://msdn.microsoft.com/en-us/library/cc707787.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

emadseed
Starting Member

5 Posts

Posted - 2013-02-11 : 05:47:30

thank you for fast reply,

exactly this what happened when I try to attach my data base in
SQL 2012 it requires me to add full text catalog, and I've no idea about this matter.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 05:57:39

see this KB article

http://support.microsoft.com/kb/240867

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

emadseed
Starting Member

5 Posts

Posted - 2013-02-11 : 06:35:14

would you mind please to provide me one,2,3 steps to solve my problem and get out of this problem..

I've no previous created a full text catalog to copy, move or to backup it.

any other idea,,

thank you much,,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 07:21:01

quote:
Originally posted by emadseed

would you mind please to provide me one,2,3 steps to solve my problem and get out of this problem..

I've no previous created a full text catalog to copy, move or to backup it.

any other idea,,

thank you much,,

Article suggests the steps to be followed clearly so I dont think I need to add anything to that.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

emadseed
Starting Member

5 Posts

Posted - 2013-02-11 : 12:57:47

article is talking about much things that I can't understand. as I told you above I am a binger in sql and I couldn't recognize the specific steps for my problem.

I'll try to reread the article.

any way thank you for your help and politeness.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-11 : 22:52:21

you're welcome

let us know if face any difficulties with specific steps in it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

emadseed
Starting Member

5 Posts

Posted - 2013-02-12 : 06:55:27

Great it works,,

•I moved my data files to data folder where master database and other databases are.

Best Regards ,,

Emad/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-12 : 09:54:23

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources