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 |
|
innocent73
Starting Member
20 Posts |
 Posted - 2002-08-23 : 04:45:04
|
| Hi,I have created a database on SQL Server 2000.How can I migrate my SQL Server database to MSDE.I know something about DMO but not sure..PLEASE HELP..Very very URGENT |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-23 : 09:09:47
|
| The easiest way is probably to make a backup of your SQL2000 database and restore it to your MSDE instance. Another way would be to use sp_detach_db , copy the files across to your MSDE instance and then use sp_attach_db to attach it.HTHJasper Smith |
 |
|
|
|
|
|
How Can I Migrate My SQL Server Database to MSDE??