sql server programming: best way to sync a table in 2 SQL Express 2005 DB's -- sql server programming

Re: best way to sync a table in 2 SQL Express 2005 DB's

Hari Prasad
1/31/2007 6:45:49 AM

sql server programming:

Hello,

Take a look into Trasnactional replication. This will syncronize the
subscriber database when ever the data in publisher database changes.
Take a look in books onliline on steps to configure.

Thanks
Hari

[quoted text, click to view]

best way to sync a table in 2 SQL Express 2005 DB's

Rotsey
1/31/2007 10:56:18 PM

Hi,

I have 2 SQL Express 2005 Databases with a table that I want to synchronise
between them.

The rows will be minimal.

I want to know the best way to do it. I am devolopiing in .NET as well.

I could do it manually in .NET code but I thought there would probably
be better way.

One thing I thought of is I could create a trigger so that when a row
is updated in one it updates the other database, but how????

rotsey