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 |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2006-08-05 : 13:22:00
|
| I have locally 2 tables the main, say tblMain, with an identity column called M_Id as a key and another tblSub having for key S_M_Id (foreign key from tblMain) and S_C_Id (foreign key from another table). The same tables exist on my hosting's server. I would like to sync those 2 tables, in other words all new records added to local tables will be copied to my hosting's server. I tried importing from my hosting's but as they are "holes" in tblMain (records can be deleted locally) it didn't work as I was expecting, I found out that locally I had 3100, 3102 and that imported gave 3100, 3101.How should I do this ? I need to run the sync manually about every week. Keep in mind that my SQL Server is located on a shared hosting environment where they are probably some restrictions.jean-lucwww.corobori.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-05 : 13:27:28
|
| How big are the tables - might be easiest just to copy all the data.If not what access do you have between the servers?Linked server?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2006-08-05 : 14:24:36
|
| I am connecting to the remote Server using Enterprise Manager, I tried copying the data but despite being just a few records it didn't work out fine.jean-lucwww.corobori.com |
|
|
|
|
|
|
Sync tables