SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 convert database from 2005 to sql 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

emadseed
Starting Member

Yemen
5 Posts

Posted - 02/11/2013 :  00:52:21  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 02/11/2013 :  00:59:13  Show Profile  Reply with Quote
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/

Go to Top of Page

emadseed
Starting Member

Yemen
5 Posts

Posted - 02/11/2013 :  05:47:30  Show Profile  Reply with Quote
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.

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/11/2013 :  05:57:39  Show Profile  Reply with Quote
see this KB article

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

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

Go to Top of Page

emadseed
Starting Member

Yemen
5 Posts

Posted - 02/11/2013 :  06:35:14  Show Profile  Reply with Quote
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,,

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/11/2013 :  07:21:01  Show Profile  Reply with Quote
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/

Go to Top of Page

emadseed
Starting Member

Yemen
5 Posts

Posted - 02/11/2013 :  12:57:47  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/11/2013 :  22:52:21  Show Profile  Reply with Quote
you're welcome

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

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

Go to Top of Page

emadseed
Starting Member

Yemen
5 Posts

Posted - 02/12/2013 :  06:55:27  Show Profile  Reply with Quote
Great it works,,

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


Best Regards ,,

Emad/
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/12/2013 :  09:54:23  Show Profile  Reply with Quote
welcome

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000