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 |
|
syntax-error
Starting Member
1 Post |
 Posted - 2009-01-26 : 03:18:47
|
| Is this possible with the use of SQL Server Management Studio Express?If yes could somebody teach me how?Here's the catch tho, I can't use a backup method, nor the use of MDF files.My goal is, to copy a database on a MS Sql server 2005 express to another MS Sql server 2005 express. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-27 : 14:32:51
|
| Then you have to do hard work by scripting everything ,exporting data to other server. |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-01-27 : 14:41:06
|
| What about the sp_detach_db and then then sp_attach_db |
|
|
|
Doron
Starting Member
6 Posts |
Posted - 2009-02-12 : 06:21:20
|
| 1. Detach the database using right click->Tasks->Detach2. Copy the MDF file from the old server to the new server3. On the new server attach the file using right click on "Databases" and "Attach".You can also enjoy our tools on www.nobhillsoft.com ...Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)www.nobhillsoft.com |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-12 : 06:28:03
|
And don't forget to fix security and logins so they match the database and server.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Copy a database from one server to another?