September 23, 2007 at 5:57 am
Hi,
My 2 servers are behind a firewall and file sharing is disable. How can I setup transactional replication between the two without having to share a folder that is used for snapshot file.
Thanks,
September 24, 2007 at 5:32 am
You can manually set up the database and not use a snapshot. The down side will be that you will be unable to simply re-initialize the database and have it automatically re-create the schema from a snapshot. You would always have to be prepared to use a database backup manually to reinitialize.
However, I think there is another option. With merge replication, you can configure the database to use FTP for the database snapshot. I don't seem to remember being able to do this with transactional replication, but I could be wrong. If you cannot, you may be able to set up just snapshot replication using FTP rather than a file share and then use this snapshot to initialize your transactional replication. Look up FTP Snapshot in books online to get started.
The other option would be to have your administrator set up a folder that both machines can access. This can be done safely, securely, and with very little effort and it would completely eliminate your issue. I would recommend this route since replication can get really complicated if you start to stray from the default behavior.
September 24, 2007 at 8:46 am
With PUSH subscriptions you don't need to share the snapshot Folder.
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply