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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-25 : 08:18:46
|
| Deepak writes "Dear Sir/Madam,How to Migrate SQL Server 2000 Database to MSDE, since as far i read on net the drivers for MSDE are the same as for SQL Server, then how to do the same, and is it mandatory to have SQL Serveron the local machine where MSDE is installed.Because right now i dont have SQL Server installed on my machine, as when i went for installation of MSDE on the machine it corrupted SQL Server.When i am trying to Migrate SQL Server 2000 database presenton remote machine to this machine where i have MSDE installed, I am facing a problem???(Does i have to go to some third party drivers for MSDE???)Waiting for ur answer on these questionsWith RegardsDeepak" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-06-25 : 08:35:20
|
| msde is a run time distributable version of sql server so you don't need sql server as well.You can detach the database from sql server and attach to msde.You will need the correct version of msde though. msde2000 for v2000.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Migration Of SQL database to MSDE