That sounds like a good plan. I assume you can lose the use of the SQL Server for a while.

I know this is an old thread, but it might help. I am trying to solve a problem and came across this. It looks like 2008 does now...

If it is just for 2 logins, then follow my previous post on how to create the login and specifiy the...

A couple things to try. Try to connect to the database through Management Studio with one of the logins, preferably one from the site, and see if that login...

If latency is an issue, replication works well. It can tolerate failures pretty well. One of the draw backs is that sometimes in 2000, replication will stop when one...

When you create the logins on the destination server, you need to use the sid from the source server. The sids on the logins are not aligned because they...

I think your syntax may be incorrect. If you are inserting into DB2, then the IDENTITY_INSERT needs to be on for that table, not the source table DB1. ...