Replicating between MSDE and SQL 2000

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 =---

William
Fri Feb 06 16:01:23 CST 2004

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.
__________________________________

<John@hokykoky.com> wrote in message
news:gnd62053h4j3d7s00pn1mvlnmnbe38bbeq@4ax.com...
> 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
Fri Feb 06 17:23:22 CST 2004

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

On Thu, 05 Feb 2004 22:44:52 -0800, "John@hokykoky.com"
<John@hokykoky.com> wrote:

>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 =---

C
Fri Feb 06 08:45:54 CST 2004

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

John@hokykoky.com schrieb:
> 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 =---