how to dump database to MSDE

Hi

In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net

1.how to dump my sqlserver database which i was already using to theMSDE and

2.can i connect this MSDE to MSSqlServer2000

hi,

GRK wrote:

Hi

In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net

1.how to dump my sqlserver database which i was already using to theMSDE and

you can "move" the database from the SQL Server 2000 to the MSDE instance in 2 easy ways..

1. you can backup (full backup) the database on the original machine, move the backup to the MSDE machine, restore the database onto the MSDE instance..

2. detach the database from the SQL Server 2000 instance, copy all database files to the MSDE machine, attach the database to the MSDE instance (and obviously reattach the original database to the original SQL Server 2000 instance)..

you obtain the very same result, and you have to deal with the very same issues.. eventual "Orphaned Users"..

2.can i connect this MSDE to MSSqlServer2000

the question is not clear to me.. if you mean to "access MSDE from the SQL Server 2000" instance as a linked server (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp as well), then yes, this is possible... a "commercial" issue is present as this connection has to be properly licensed...

regards

|||

Hi Andrea ,

Thank you verymuch.

-GRK