how can i synchronized multiple sql server

[viku]

hi!
all.

i want to create a web application architechture which having multiple web server.
this all web server having sql server database.
now what i want is to Keep all data in all databases.
means i want to synchronize my all sql servers.
it is also possible ki my one webserver can have multiple clusted database.
hope to hear soon from u people.

Regards
Viky

 

[wilk]

few ideas.

dts the data as a scheduled task.

bcp into text files and then bulk insert into the other databases. This can all be done from the dos prompt so does not require any more porgramming than a simple grasp on batch files. We use this to distrubte our data with great succcess. we set up a transfer flag to show what data has changed and then bcp from a view of the table. We also use a quite clever stored procedure that inserts the data into the next database.
We use this method becauase none of the computers are connected to us

sql replication. This is probably the best aproah of the computers are all connected and you wish to keep them in sync to within about a minute. It causes a bit of netwoork trafic but who cares, apart from the network guys.

These will all work, but becareful of those foriegn keys.