Last post Dec 31, 2008 07:11 AM by TATWORTH
Dec 30, 2008 12:03 AM|abhims|LINK
Dec 30, 2008 02:23 AM|Mikesdotnetting|LINK
You are talking about Replication:
Dec 30, 2008 12:52 PM|TATWORTH|LINK
Where are the two databases located with respect to each other?
What ports are open between the two locations?
Dec 30, 2008 01:24 PM|abhims|LINK
Dec 30, 2008 01:43 PM|TATWORTH|LINK
Where is the remote server in relationship to the local server?
Are they members of the same domain?
Are they on the same LAN?
Is the remote server across the intenet?
What firewalls lay between them and what ports are open from end to end?
Dec 31, 2008 01:43 AM|abhims|LINK
Dec 31, 2008 02:39 AM|TATWORTH|LINK
>Yes, the remote server is across internet. No firewalls
There are probably one or more firewalls en route. Therefore ports 1433 and 1434 are unlikely to be open throughout.
You need to think about using a web service type solution to push and pull data. You therefore there a unique Id on each table plus a an update count. Are records deleted from the database?
Dec 31, 2008 06:46 AM|abhims|LINK
Dec 31, 2008 07:11 AM|TATWORTH|LINK
If the servers at both ends are synchronised to a common time source, then the job simplifies slightly.
You will need to add two fields: