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.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Transferring database/data from sql server to msde

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-13 : 08:12:38
Sakmer writes "Hi,
I have a SQL server2000 database on the internet, the front end is VB. I want to install MSDE2000 on the client side, for daily transactions, which then will be transferred once a day onto the central sql server database. Since my Central database is up and running I wish to make a database script and transfer the table structure and later all the data to MSDE (local database). Now which utility can I use to do this (i believe I can use Access to access MSDE database), but can I run a script to install tables and data on MSDE? Any help will be appreciated.
Thanks"
   

- Advertisement -