Synchronising a database on 2 machines.

Question

Synchronising a database on 2 machines.

yogiberr

Hall of Fame

Points: 3679
More actions
August 28, 2003 at 2:51 am

#82410

Hi folks,
I have 2 non-networked machines:
i)machine1
ii)machine2
In order to transfer the database from machine1 to machine2,
I normally:
1) copied the mdf and ldf files from machine1 on to cd.
2) attached them to machine2.
Now, the databases are not in sync.
(I am therefore unable to do a direct copy)
This is because:
i) machine1 database has new sprocs and updated tables.
ii)machine2 database has updated tables.
I would like the database on machine2 to:
i) keep the changes to its updated tables.
ii) import the changes that have occurred in the machine1 database.
Is there any way to achieve this?
Cheers,
yogiberr

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Prakash Heda SSCertifiable Points: 5539 More actions · Answer 1

No direct way to do that....

You can try "log explorer" to generate script for the changes made to one of the database and can implement those changes to other database....

Cheers..

Prakash Heda

Sr Consultant DBA

Bangalore, India

Chat: hedafriends@yahoo.com

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA

yogiberr Hall of Fame Points: 3679 More actions · Answer 2

Hi Prakash,

I'll give the free download a try.

Many thanks for taking the time.

Cheers,

yogiberr

NPeeters SSChampion Points: 12610 More actions · Answer 3

A second approach could be to attach the machine 1 databases on machine 2 on a different database. If that's done, you can copy only those objects from one database to the other.

Of course, this is manual labour, so it can be a lot of work and errorprone.