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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-04-15 : 08:32:16
|
| Hi,We are in planning to migrate from 2000 standard to 2008 standard. As part of migration, am working on replication but i believe that sql 2000 replication scripts are not working in sql 2008.So, what i thought of is to setup the replication in 2008 using GUI rather using sql 2000 scripts.During this process, i have question on Delivery format of the sql statements In 2000, i can find options line - Replace INSERT commands with the stored procedure call- Replace UPDATE commands with the stored procedure call- Replace DELETE commands with the stored procedure call - Send parameters in binary format- USe column names in commands that are not replaced by the stored procedure.In 2008,Below are the list of properties i can see it for INSERT,UPDATE & DELETE operationsProperties for the Articles Statement delivery INSERT delivery format | Call <stored procedure> Do not replicate INSERT Statement INSERT Statement INSERT statement without column list UPDATE delivery format | Call <stored procedure> Do not replicate UPDATE statements UPDATE Statement <MCALL storeprocedure> XCALL stored procedure SCALL stored procedureDELETE delivery format | Call <stored procedure> Do not replicate the DELETE statements DELETE Statement XCALL <stored procedure> But could not find any option to send the parameters in BINARY format where can i find it is my question ??????????????Thanks, |
|
|
|
|
|
Replication migrate 2000 to 2008