October 16, 2001 at 7:35 pm
Hi guys,
My Qns:
1) Must the tables, data types, length be the same between my external(production) and internal(intranet) sql server?
2) Can i do an export of all the data records(from all the tables) from my external sql server, and import it from my internal?
Thanks guys!
October 17, 2001 at 5:13 am
No, they don't have to be the same. Usually they are, but with a little work you can handle this. Not sure you should though. One of the nice things (to me anyway) is that if something happens and a subscriber gets out of sync, I just blow away the table and repopulate - as described below. This only applies to replicated tables - you can have all the other objects you want.
The replication wizard will handle the export/import for you. Basically it scripts out all objects being replicated, bcps the data out, then applies the scripts to the subscriber and bcps the data back in - this is the initial 'snapshot'.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply