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 |
|
daimne
Starting Member
17 Posts |
 Posted - 2008-10-08 : 11:55:19
|
| We have multiple MSDE databases some coming with COTS application - is it possible to migrate them to the EE SQL Server?TIA |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-10-08 : 14:01:36
|
| The database can certainly be moved to another instance of SQL Server. The bigger question is can the COTS application support having the database move? Not all applications can deal with a database that changes location. This may require as little as a config file change, or as much as a reinstall of the application. Your best bet is to contact whoever supports COTS. |
 |
|
|
daimne
Starting Member
17 Posts |
Posted - 2008-10-08 : 16:52:01
|
| Thanks!To move the database you have to either detach it or back it up. How could you do it with MSDE without Enterprise manager? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-10-09 : 14:14:37
|
| Use OSQL, and read up on the BACKUP and RESTORE commands. |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-09 : 19:29:10
|
| YOu can upgrade MSDE to hihgher version like standard |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-09 : 19:54:12
|
| MSDE has been replaced by the MS SQL Express versions |
|
|
|
|
|
|
Is it possible to migrate MSDE database