Results 1 to 5 of 5

Thread: Please Help

  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Question Unanswered: 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

    Nick

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    look into sqlcompare

  3. #3
    Join Date
    Dec 2002
    Posts
    29
    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!

  4. #4
    Join Date
    Dec 2002
    Posts
    29
    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!

  5. #5
    Join Date
    Dec 2002
    Posts
    29
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •