April 15, 2010 at 6:09 am
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 operations
Properties 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 procedure
DELETE 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,
April 21, 2010 at 2:14 pm
Use MCALL in Update delivery format option. It will pass binary value that is last parameter of procedure used
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 23, 2010 at 1:28 am
Mohan,
what about INSERT and DELETE if i want to sent in BINARY format???
April 23, 2010 at 9:21 am
Mahesh
I misunderstood your question. Hence option that I suggested is not something that you were looking for. If I understand your question now correctly then you are looking for an option that can allow you to specify "parameters in binary format" what we used to have in SQL server 2000. You can achieve this by using schema_option parameter of sp_addarticle
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 23, 2010 at 9:24 pm
Mohan, when am trying to access the url am getting the 404 error.
Server Error
404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Anyways, thanks. Will check the option in MSDN>.
April 23, 2010 at 11:50 pm
I just acccessed url and it worked.. Please try again...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply