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 2005 Forums
 SQL Server Administration (2005)
 Moving Database from SQL 2000 EE to SQL 2005 SE

Author  Topic 

srikanth12
Starting Member

22 Posts

Posted - 2010-03-22 : 18:14:06
Hi All,

Could any one of you please let me know whether we can migrate the database from SQL 2000 EE to SQL 2005 SE? I know that for in_place upgrade we cannot do but just want to find out whether is it possible to do with side by side migration. Need some quick response please.

Thanks in Advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-22 : 18:43:47
Yes you can do it with backup/restore or detach/attach.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

srikanth12
Starting Member

22 Posts

Posted - 2010-03-22 : 19:36:25
Great!!! Thanks Tara.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-22 : 21:14:03
No problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -