August 8, 2003 at 4:48 pm
I have two SQL servers that need to be synchronised on an hourly
basis. The master is behind a firewall that only allows HTTP and
secure FTP (SSL) access. FTP access is one way only, so the slave
database cannot FTP into the master. No other ports or VPN are available so
the usual methods of replication seem to be out without any
possibility of altering the security on the firewall. The slave
database will not be amended so a snapshot replication is possible
although I'd like to keep filesizes down to a minimum.
The way I thought it might work is this:
1. Create compressed CAB snapshot file
2. Use 3rd part secure FTP client to put file on slave server
3. Create Pull subscription pointing to uploaded CAB file.
However, I've been unable to get this working. Does anyone have any
ideas on how I could get this scenrio working? It doesn't have to rely
SQL server schedules, at the moment I'm looking at doing this manually
before seeing how it can be automated.
thanks
Andrew
--------------------------------------
Andrew Price
Box UK
Internet Development and Consultancy
t: +44 (0)29 2022 8822
f: +44 (0)29 2022 8820
--------------------------------------
August 11, 2003 at 8:00 am
This was removed by the editor as SPAM
August 11, 2003 at 8:11 am
Which part isnt working?
Andy
August 12, 2003 at 3:47 am
I can create the CAB file and upload it OK but cannot get the slave database to read the file. Essentially, what I have at this point is a standalone SQL server and a snapshot replication file in CAB format from another SQL server.
August 12, 2003 at 7:17 am
Could you get away with using transaction log shipping?
August 12, 2003 at 8:20 am
Due to sensitive information being held on the master, not all data will be replicated.
Maybe I could created another database on the master that was a replication of the main database with filtering to remove sensitive data. I could then use transaction logging on this secondary database to update the remote database.
Does anyone foresee any problems with this approach?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply