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 2008 Forums
 SQL Server Administration (2008)
 database migration

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2011-09-26 : 02:55:10
Hi,
my database is on sql server 2008 XE. now i want to migrate my database to another server which is running sql server 2008 enterprise edition.. i tried to migrate by doing detach and then attach, but i m getting error related to version...can u plz tell me..how to migrate??

thanks...

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-26 : 04:23:30
Use backup - restore instead...

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

pramod21
Yak Posting Veteran

64 Posts

Posted - 2011-09-26 : 05:18:45
backup - restore is also not working.......
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-09-26 : 05:34:40
quote:
Originally posted by pramod21

backup - restore is also not working.......




Whats the Excat error ? any comaptiblity issues?

Tryed with SSIS package?

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page
   

- Advertisement -