You can also register all sql server instances in SQL Server Management studio under one group and then can run a single query on that group which will be executed...

Database mirroring is also a good option but there is a limit on how many databases you can mirror. I would recommend using log shipping to do the migration...

Thanks! Steve

Datacenters are very far apart. We are planning to put the database on tape and send it to second datacenter and copy the transaction log files over the network...

Yes, We re-initialized the subscription. It created new snapshot and applied successfully on subscriber.

Execute below command and see if it returns the same server name, that you are using in SSMS to connect to it.

SELECT @@SERVERNAME

If it returns different name, means you...

Thanks a lot! for sharing workaround.

Thanks a lot! paul

But i am looking for the work around that SQL Server does not issue the Create table statement to Oracle when I selected the Option in...