| Author |
 Topic  |
|
|
emadseed
Starting Member
Yemen
5 Posts |
 Posted - 02/11/2013 : 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
India
47157 Posts |
Posted - 02/11/2013 : 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
Yemen
5 Posts |
Posted - 02/11/2013 : 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
India
47157 Posts |
|
|
emadseed
Starting Member
Yemen
5 Posts |
Posted - 02/11/2013 : 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
India
47157 Posts |
Posted - 02/11/2013 : 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
Yemen
5 Posts |
Posted - 02/11/2013 : 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
India
47157 Posts |
Posted - 02/11/2013 : 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
Yemen
5 Posts |
Posted - 02/12/2013 : 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
India
47157 Posts |
Posted - 02/12/2013 : 09:54:23
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
convert database from 2005 to sql 2012
