Wednesday, March 21, 2012

Remote to Remote

Hi,

We have 3 database server . one is local and other two are in two different locations.

Scenario is , we have to import a database from one old remote server to another new remote server.
Since, it should be difficult (bcoz of firewall issues) to import from old remote to new remote server, i thought to
import to my local DB server then import database to new remote server.

I am planning to give IMPORT/EXPORT option in the ALL TASKS property, from my local m/c to the old remote server.
then take BACKUP database in my local machine . After that just copy the backup file to my new Remote server and then
just restore it.

Or is there any better solution to accomplish this ?

Please give me some advice !

Thanks,

HadleyWhy not consider using REPLICATION or LOG SHIPPING kind of solution rather depending on roundabout solution. Refer to books online for more information.

No comments:

Post a Comment