sync'ing 2 databases - Microsoft SQL Server

Piotrek Stachowicz

Hello,
I've got 2 databases (both on MS-SQL Sever2k). One of them (remote)
contains table which is often updated. For various reasons I'd like to
maintain a copy on local MSSQLServer. Is there any built-in mechanism which
allows to do such things?! I can do this manually, by examining the remote
table contents, and downloading new stuff (local table cannot be modified in
any other way), but I guess that there is a smarter way. Any ideas?!
Thanks

Piotrek

Jul 20 '05 #1

Subscribe Post Reply

1279

Allan Mitchell

If you want the table locally to be a transaction * transaction copy then I
would look at either

Transactional replication OR
Building triggers on the Remote table and doing the logc myself.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Piotrek Stachowicz" <dy******@poczta.onet.pl> wrote in message
news:cd**********@news.onet.pl...

Hello,
I've got 2 databases (both on MS-SQL Sever2k). One of them (remote)
contains table which is often updated. For various reasons I'd like to
maintain a copy on local MSSQLServer. Is there any built-in mechanism which allows to do such things?! I can do this manually, by examining the remote
table contents, and downloading new stuff (local table cannot be modified in any other way), but I guess that there is a smarter way. Any ideas?!
Thanks

Piotrek

Jul 20 '05 #2

Similar topics

don't sync() on an fstream at EOF

by: kartik | last post by:

I open an fstream in read-only mode, read till the end, then try to sync() before seeking to position 0 & reading again. But the sync fails. I discovered that clear()ing the stream before the sync...

C / C++

incompatiable data sync

by: someguy | last post by:

Hi, We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend...

Microsoft SQL Server

CVS for Databases?

by: Nimit | last post by:

Hello! I have developing a PHP/MySql web application with a team. We are all located in different locations, so we cannot have anything running on one local server. We have a CVS setup on a...

PHP

Looking for reviews of MS Access databases for the Palm OS

by: Joe Wasik | last post by:

Hello, Currently I used Biomobility's DataOnTheRun for the Pocket PC. It's a little slow, but it does exactly what I need -- and it does it well. Unfortunately, now I need to have the same...

Microsoft Access / VBA

Sync'ing Enums to Database values.

by: narshe | last post by:

I haven't come across an elegant way to do this yet, and would like to know what other people have come up with. There are two tables: CREATE TABLE EmployeeStatus ( pkId int not null primary...

C# / C Sharp

Sync to databases nightly with BLOB data

by: sql guy123 | last post by:

I need some assistence here. I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS desktop engine). I need to sync my databases nightly, as a backup. Is there a cheap...

Microsoft SQL Server

Xlib sync on different instance of Xlib.display.Display()?

by: Ferry Boender | last post by:

Hi, I'm relatively new to Xlib programming, and I ran into a little problem. I'm trying to insert keypress events into a X window. The following code works: ...

Python

Database Business Layer and Database Sync Design

by: morleyc | last post by:

Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....

C# / C Sharp

anydbm and sync'ing

by: Torsten Bronger | last post by:

Hallöchen! A TurboGears process opens a DB file with anydbm and keeps it open. The the same time, this file is updated by another process. How can I tell the TurboGears process to fetch the new...

Python

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

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

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

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

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++