>>We do this using replication.
>
>Can you elaborate more on that topic?

http://www.code-magazine.com/Article.aspx?quickid=0311101
http://msdn.microsoft.com/en-us/library/aa933510(SQL.80).aspx

I don't know what version you have (I just saw the 6.5 and earlier - sorry about that), but these are nice:

http://blogs.msdn.com/euanga/archive/2006/07/18/668916.aspx
http://www.sqlteam.com/article/replicating-sql-server-2000-across-heterogeneous-databases

A neat script for 2005 to get schema options:

http://www.replicationanswers.com/ScriptSchemaOptions.asp


A good site on replication scripts period:

http://www.replicationanswers.com/Scripts.asp

Now that I see you are using an older version, your replication options are limited.