Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Syncronize database

1 view
Skip to first unread message

Dara Bunhim

unread,
Apr 30, 2003, 5:44:13 AM4/30/03
to
Hi,

Is there any way that I could sincronize two sql database wich base on two
different machines?

Thanks
Dara


Hilary Cotter

unread,
Apr 30, 2003, 7:36:48 AM4/30/03
to
It depends what you mean by synchronization and how in
sync you need them.

IF its a one time shot and you need the system tables as
well, I would back up the database, create a shell
database on the new server, script the logins and database
users from the old server, run it in the new server's
shell database, and then restore the backup there.

you could also use DTS to copy server objects to do this,
or snapshot replication.

If you need the databases to be always in sync, consider
transactional replicaiton.

>.
>

Dara Bunhim

unread,
Apr 30, 2003, 10:14:35 PM4/30/03
to
Thanks you very much for ur information.

I like to have transaction syncronize, what is the best way I should do it
since the database has to syncronize online throught the internet.

Dara


"Hilary Cotter" <hil...@att.net> wrote in message
news:063101c30f0c$c9528b00$a501...@phx.gbl...

0 new messages