开发者

What is a good SQL Server strategy for copy/move database tables between two location in different networks?

What would be the best strategy for a SQL server database copy/move from a source location separated by the Internet to a destination? (preferably automated)

The destination will not need to alter data but will require query access.

  • In this case both locations are not connected by VPN.
  • They are on different domains/networks.
  • The frequency of getting the copy from the source will be approximately twice a month.
  • Assuming both sites are using MS SQL Server 2008 (not Express/Standard editions).
  • Can include strategy with differential backups if suitable
  • Prefer to use a MS SQL Server solution rather than custom programmatic solution
  • Initial Database size and the incremental changes might be approximately ~150MB

Possible solutions I can think of:

Snapshot Replication with FTP - the only problem is trying to Automate the FTP connection in retrieval. Also provides flexibility with Articles that can be chosen. But the tables require Primary Keys (PK)

Log Shipping (Recovery in Standby mode) - the problem here is copying and retrieving the T开发者_开发知识库ransaction Logs from the folder; as they are on different networks.


For a single 30MB database twice a month, I would use an SSIS package which can handle either backup/restores or dumping /reading tables and the associated FTP

The fact of no direct connection limits your options immensely (replication, log shipping, mirroring etc)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜