Please Help

Help needed to keep 2 SQL Server 2000 databases in sync.

I am developing an application in .NET which uses an SQL Server 2000 backend. I am developing at home on a workstation at night and during the day when possible on my notebook. Both these machines have SQL Server 2000 installed, if I change anything in the database on one machine or the other, I currently have to replicate the changes to the other machine, is there a really simple way to keep these two databases in sync with a batch job or anything?

TIA

Nicklook into sqlcompare|||Originally posted by ms_sql_dba
look into sqlcompare
Where? 'cause I am interested too.

I usually use Visual SourceSafe for the structure comparison, then jobs for the data update. If there is something simpler than this, I am interested!

Best regards!|||Originally posted by ms_sql_dba
look into sqlcompare
Where? 'cause I am interested too.

I usually use Visual SourceSafe for the structure comparison, then jobs for the data update. If there is something simpler than this, I am interested!

Best regards!|||Originally posted by ms_sql_dba
look into sqlcompare
Where? 'cause I am interested too.

I usually use Visual SourceSafe for the structure comparison, then jobs for the data update. If there is something simpler than this, I am interested!

Best regards!