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-10-01 : 09:14:09
|
| Bob writes "Hi, I have a database from MSSQL 2000 and would wish to export it to MSDE 2000 for my application. How am I to do it? And from my application which is written from VB6 how am I to retrieve the data using store procedure.Thanks,Bob" |
|
|
Shaner
Starting Member
9 Posts |
Posted - 2002-10-01 : 11:54:17
|
| Hey Bob...Im pretty sure all you need to do is instal MSDE 2000 on your target server. Then attach or restore a backup of the SQL Server 2000 DB. Keep in mind youre going to lose some functionality with MSDE. Like no client tools to work with. Youll need to use osql or a 3rd party tool to maintain your DB. You have some DB size limitations...and no SQL Server Agent for scheduling jobs.Shane |
 |
|
|
|
|
|
Export database from MSSQL 2000 TO MSDE 2000