Hi

I'm developing a program that uses SQL Server 7. I've created the database using the developers version of SQL Server 7 that came with Visual Studio.

When I eventually deploy the application, the database will be run from MSDE.

My question is, how do I transfer my database from SQL Server 7 to MSDE?

I've tried the DTS Inport/Export but I get a message telling me that my licence doesn't allow me to use DTS.


Also, how can I administer MSDE and add password. MSDE doesn't have an Enterprise Manager.



Thanks.