August 29, 2007 at 6:45 am
Try to do a snapshot replication. The field type on Publishier is char(1) and on Subscriber is varchar(1). The replication fails.
Getting the following error:
Error messages:
The process could not bulk copy into table '"GRS"."GRS_IMG_NAMES"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
Data conversion failed
To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
bcp "OneACS"."GRS"."GRS_IMG_NAMES" in "D:\Microsoft SQL Server\MSSQL\ReplData\unc\USER-001_MA_HAMPSHIRE_MA_HAMPSHIRE\20070829173640\GRS_IMG_NAMES_2#1.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SUSER-001 -T -w (Source: MSSQLServer, Error number: 20253)
Does anybody know if I can do that or structures have to be same?
Thanks in advance
TH
August 29, 2007 at 10:06 pm
I believe that you have to set them the same. Snapshot is nothing but a copy.
August 30, 2007 at 12:20 am
Is it normal that data import works fine and replication doesn't?
When I do the import it goes smoothly, but replication crashes?
Thanks
TH
September 4, 2007 at 2:18 pm
In my personal point of view, it is possible that a data import works fine and replication may not. Data Import can be constrained to data only. But a replication, starting from a snapshot, is an exact copy of a data structure.
September 4, 2007 at 5:10 pm
And if you are not DROPing the destination objects bcp generates the files in native mode . That is why the types must be IDENTICAL.
* Noel
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply