473,382 Members | 1,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Replication with MSDE

I have a distributed inventory control database that I am going to
migrate from Access to SQL Server. I am going to use SQL Server
Replication to keep the data current.

There will one SQL Server 2000 database at HeadOffice, and about 200
branches will each have MSDE 2000.

For tables that are the same for each branch (e.g. StockItems,
Suppliers), I'm going to use Transactional replication with the
HeadOffice as Publisher. There is no need for Merge replication,
because only HeadOffice will be changing this data.

For tables that are updated at the branches (e.g. deliveries, sales),
there shouldn't be any
conflicts either, as each branch will only update data that is
specific to it. So, transactional
replication with the Branches as Publishers seems like the answer.
BUT, MSDE 2000 only handles merge replication as a publisher, so it
looks like I'm going to have to use Merge Replication if I'm am going
to use MSDE.

Question: Do you think that it worth buying a full SQL Server licenses
for each branch, so that I can use Transactional replication with the
branches as publishers. Or, should I stick with MSDE 2000 and Merge
replication. Also, are there any other reasons why MSDE won't be
adequate as the database at the branches.

Thanks,
Craig
Jul 20 '05 #1
1 5445
You seem to have two main questions - is it worth spending the money to be
able to implement transactional replication instead of merge; and is MSDE
generally suitable for your situation.

For the first question, I would consider asking it in
microsoft.public.sqlserver.replication - replication is a large topic, and
you may well get better advice in a specialized group (which isn't to say
that no one here knows anything about it, just that I don't know that much
about it myself, and so I would ask in a dedicated forum).

For the second point, I suggest you review the MSDE product information
here:

http://www.microsoft.com/sql/msde/pr...o/features.asp

The main limitations that might affect you are that you are limited to 2GB
databases, and performance drops quickly when you have more than 5
connections.

Simon

"Craig HB" <cr*****@bigfoot.com> wrote in message
news:3b**************************@posting.google.c om...
I have a distributed inventory control database that I am going to
migrate from Access to SQL Server. I am going to use SQL Server
Replication to keep the data current.

There will one SQL Server 2000 database at HeadOffice, and about 200
branches will each have MSDE 2000.

For tables that are the same for each branch (e.g. StockItems,
Suppliers), I'm going to use Transactional replication with the
HeadOffice as Publisher. There is no need for Merge replication,
because only HeadOffice will be changing this data.

For tables that are updated at the branches (e.g. deliveries, sales),
there shouldn't be any
conflicts either, as each branch will only update data that is
specific to it. So, transactional
replication with the Branches as Publishers seems like the answer.
BUT, MSDE 2000 only handles merge replication as a publisher, so it
looks like I'm going to have to use Merge Replication if I'm am going
to use MSDE.

Question: Do you think that it worth buying a full SQL Server licenses
for each branch, so that I can use Transactional replication with the
branches as publishers. Or, should I stick with MSDE 2000 and Merge
replication. Also, are there any other reasons why MSDE won't be
adequate as the database at the branches.

Thanks,
Craig

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Craig HB | last post by:
I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server...
1
by: KWilliams | last post by:
Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 -...
0
by: occularrifts | last post by:
My Company currently has a database that is being replicated to an MSDE Database on several laptops. Replication is anonymous, merge over TCP/IP. I am in need of a way to generate a monthly...
4
by: pheonix1t | last post by:
hello, also wanted to confirm which versions of sql2000 can do replication. Would be nice to have fault-tolerance via replication so as to have a hot-standby. Oskar
1
by: ansonee | last post by:
I'm trying to find a central website/group that lists what is possible with regards to replication depneding on your OS. For example, is transactional replication supported on XP Pro and SQL...
2
by: HJ | last post by:
Hi all, I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. The...
8
by: Rick | last post by:
I'm running an Access2000 front end mde linked to an Access2000 back end mdb. I need to set up replication and synchronization of only the data tables between the master db on the pc and replicas...
3
by: Chris Rennert | last post by:
Hello all, We were just getting started on a small project using SQL Server Express on our PC's and we already had SQL Server 2k Enterprise on our main Server. Problem is , we cannot do merge...
0
by: BOD661 | last post by:
Hi, Is it true that to operate merge replication with MSDE on a laptop / desktop to a server running SQL Server the user requires local admin rights to their laptop / desktop? Thanks
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.