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.
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|