Synchronizing two SQL Server Databases

23 Jun 2006 4:57 PM

le_mo_mo

Hi,

I am trying to have two SQL Servers (Local/remote) synchronized. I was
wondering if there are any jobs I can run to make this happen. I have
one server defined as linked server for the other. I can not figure out
how to keep the autogenerated primary keys the same! Any ideas?

Thanks

23 Jun 2006 6:28 PM

Andrew J. Kelly

Take a look at Replication in booksonline.

--
Andrew J. Kelly SQL MVP

<le_mo***@yahoo.com> wrote in message

Show quote

news:1151081871.364797.232450@y41g2000cwy.googlegroups.com...
> Hi,
>
> I am trying to have two SQL Servers (Local/remote) synchronized. I was
> wondering if there are any jobs I can run to make this happen. I have
> one server defined as linked server for the other. I can not figure out
> how to keep the autogenerated primary keys the same! Any ideas?
>
> Thanks
>

25 Jun 2006 11:35 AM

Thomas

Try www.sqlscripter.com to sync your data.

Show quote

"le_mo***@yahoo.com" wrote:

> Hi,
>
> I am trying to have two SQL Servers (Local/remote) synchronized. I was
> wondering if there are any jobs I can run to make this happen. I have
> one server defined as linked server for the other. I can not figure out
> how to keep the autogenerated primary keys the same! Any ideas?
>
> Thanks
>
>