Synchronization of database - SQL Server Forums

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

SQL Server Administration (2000)

Synchronization of database

Author

Topic

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-09 : 01:52:49

Hi,
I have a two database on two different server. How I can synch these two database.
Ex :- Db1 on server1 and Db2 on server2.

SQLTeam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-09 : 01:57:32

- Backup - Restore
- Deattach - Attach
- DTS
- Log Shipping
- Linked Server

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-09 : 04:27:32

quote:
Originally posted by khtan

- Backup - Restore
- ~~Deattach~~Detach - Attach
- DTS
- Log Shipping
- Linked Server

KH

Or you can use some third party tool like SQLCompare from RedGate to find out the differences between two DBs and sync them.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-09 : 07:18:30

table data is also possible by using this tool

SQLTeam

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-09 : 07:22:07

quote:
Originally posted by shubhada

table data is also possible by using this tool

SQLTeam

Is that question or information?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-09 : 08:21:41

question??

SQLTeam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-09 : 08:26:22

This thread is getting interesting

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-09 : 08:27:51

I think SQL Compare is just to sync schemas whereas they have another tool SQL Data Compare which allows you to sync data as well.

You can check the details by visiting: [url]http://www.red-gate.com/products/[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-09 : 16:01:20

Don't forget replication.

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-10 : 02:33:24

Don't forget replication.

I didn't get this...
Can u plz explain this ...

SQLTeam

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-10 : 10:26:23

You can sync dbs with replication.

craig79
Starting Member

33 Posts

Posted - 2007-04-18 : 04:37:00

Hi,

If u have a limited set of tables to sync on a daily basis to the destination server then creating DTS Packages for it is a better idea.And u can then shedule it to run on a daily basis without much intervention.

But how many tables are to be synced on a daily basis for ur purpose????

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources