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
 Import/Export (DTS) and Replication (2000)
 Merge Replication with Jet 4.0

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-28 : 14:08:25
Chris writes "SQL server 2000 (Publisher) and Jet 4.0 (Subscriber).

Can the following be done? If so can you point me in the right direction?

Data and schema information must be replicated to and from a remote subscriber. The schema information will always go to the subscriber. The data will go both ways. The subscriber must also be able to initiate the replication of data on-demand."

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-04-29 : 23:54:07
Chris,

To my knowledge, the replication for SQL Server only allows replication with other SQL databases.
You will probably have to write your own replication engine, but it shouldn't be too difficult. You will probably have to do it via ADOX (the ADO flavour that lets you manipulate database designs from VB/C++ etc).

Tim
Go to Top of Page
   

- Advertisement -