Moving Data Across Servers???

[ShowersDK]

Can anyone help me? I'm not very familiar with all of the difference
resources of SQL Server and I'm not sure what the best method is.

I have a table_nameA on server1 and table_nameA on server2.
I want to move any changes in data on table_name A on server1 over to
table_nameA on server2. Here is the catch... server1 can not see server2
because of firewalls, etc... but server2 can see server1 so the exchange of
data, it would seem would have to be a pull from server1 to server2. What
can I do?

Thanks,
Darren

 

[calidrake]

You have more then a few options....
1. Your best bet is to request an opening on the firewall be made for port 1433(or whatever port you have SQL Server set up on) between the two SQL Server's IP addresses. Once that is set up you should have no problem setting up a replication between them.

2. You MAY be able to import the information from Server1 just by right clicking the destination database and choosing "All Tasks" --> "Import Data". But there might be a problem because the two servers have to be able to talk to each other over port 1433. This will bring over the WHOLE database, not just the changes.

3. You can export the data on Server1 to a file, and then import it on Server2. This will also bring over the whole database, not just the changes.

4. Do a full backup on Server1 then restore to Server2, but you have to make it so it is READ-ONLY and so it can restore additional transaction logs. This will make it so that when you do transaction log backups on Server1 they will be able to be restored to Server2 each time. You will NOT be able to update Server2 with anything except the backups of Server1. Basically look up "Hot-Standby" on SQL pages and you should be able to get more information.

Books OnLine (This comes with SQL Server) will help you out too.