Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DennisTheMenace
Starting Member
1 Post |
 Posted - 2000-10-13 : 13:46:03
|
| At my local site, I have a SQL7.0 Server with 5 tables in it. At my ISP's site, I have a SQL7.0 setup identical to my local tables. In the past, to update the tables, I have used the IMPORT feature in Enterprise Manager and basically replaced the remote tables.Does anyone know of an efficient way to compare two tables and update the remote based on adds/deletions/changes to the master (local) table???FYI: There is no way for me to track date changes as the master tables are imported from a read-only database that doesn't store such info. Also, it needs to be as smooth as possible as each table contains close to 200,000 records.Any input is appreciated! THANKS! |
|
|
|
|
|
Compare 2 Tables