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
 Express Edition and Compact Edition (2005)
 Copy SQL Express DB to SQL Server?

Author  Topic 

code.mafia
Starting Member

1 Post

Posted - 2007-04-17 : 21:25:54
Can I copy a database (structure, keys, relationships, data) that I create in SQL Express to a regular SQL Server database? If so, whats the best way to do it?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-18 : 00:10:14
Yes. The best way is to backup the database in express, if necessary copy the file to the regular server, then restore the database onto regular sql.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -