Replicating between MSDE and SQL 2000

[John]

I am wanting to replicate between a local MSDE database and SQL Server
2K. I am not sure how this should be approached.

1. Do the tables on each side need to be identical?

2. Do I create the database locally and then create a mirror of it on
the SQL server or can I replicate data held within 2 different
databases.?

What I want to do is have about 50 disconnected clients connect and
replicate the data that has been collected in disconnected mode
replicated up to the SQL server and out to the other 50 MSDE
databases?

Anyideas on the best approach much appreciated.

Thanks
regards
John

 

[C. Vollmer]

John,

there is an extra newsgroup for replication, something like,
micosoft.*.sqlserver.replication. Maybe you should ask there. I only
know that a lot can be done but it is difficult.

Christoph

 

[William \(Bill\) Vaughn]

I would take this question to the microsoft.public.sqlserver.msde newsgroup.
This is really a replication question... It has little to do with ADO.NET.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

I am wanting to replicate between a local MSDE database and SQL Server
2K. I am not sure how this should be approached.

1. Do the tables on each side need to be identical?

2. Do I create the database locally and then create a mirror of it on
the SQL server or can I replicate data held within 2 different
databases.?

What I want to do is have about 50 disconnected clients connect and
replicate the data that has been collected in disconnected mode
replicated up to the SQL server and out to the other 50 MSDE
databases?

Anyideas on the best approach much appreciated.

Thanks
regards
John




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---

 

[Mary Chipman]

First of all, MSDE *is* SQL Server. It can only be a client, so you'd
need full SQLS to be the publisher (it uses a publisher/subscriber
metaphor). So you create the database on the server, create the
publication, and then enable the subscribers and the subscriptions
(can be either push or pull). For your app you'd want to use either
snapshot or merge replication, depending on your needs. See Books
Online for more info and visit Michael Hotek's web site (he's the SQL
replication guru) www.mssqlserver.com.

-- Mary
MCW Technologies
http://www.mcwtech.com