Activity overview
Latest activity by jrusso76
For those who may experience the same issue as I have, here's what I did to solve it: re-import the file into the source database.
I'd like to thank Red Gate's tech support, specially Chris Auckland, for their time, patience, and dedication. Thank you. [image] / comments
For those who may experience the same issue as I have, here's what I did to solve it: re-import the file into the source database.
I'd like to thank Red Gate's tech support, specially Chris Aucklan...
I double-checked the data structures and they are identical.
I was looking at the generated script file and I noticed the following statements: EXEC(N'DECLARE @pv binary(16)
'+N'SELECT @pv=TEXTPTR([report_file]) FROM [dbo].[reports] WHERE [id]=1252
UPDATETEXT [dbo].[reports].[report_file] @pv NULL NULL N''sY,7
I left out the rest of the binary data for brevity. However, the UPDATETEXT statement seems to be trying to insert ntext data into a text column. Could this be the cause?
Is there a way for me to send you the script files?
Thank you for your assistance. / comments
I double-checked the data structures and they are identical.
I was looking at the generated script file and I noticed the following statements:EXEC(N'DECLARE @pv binary(16)
'+N'SELECT @...
Here's the steps I took:
Started Sychronization Wizard, clicked on View SQL Script. Copying and pasting does not work as it cuts off most of the script.
I saved the script and opened it in SSMS. Tried to run it and got the following message:Msg 105, Level 15, State 1, Line 12
Unclosed quotation mark after the character string 'UPDATE [dbo].[reports] SET [report_name]='Daily_Status_Of_Accounts_Report_New.rpt', [report_file]='ÃÃà ¡±Ã¡
'.
I then opened the file in notepad, saved it with a different name and reran it in SSMS. I now get the following message:Msg 518, Level 16, State 1, Line 605
Cannot convert data type ntext to text.
The statement has been terminated.
I should note that I am synchronizing from SQL Server 2000 to SQL Server 2005. / comments
Here's the steps I took:
Started Sychronization Wizard, clicked on View SQL Script. Copying and pasting does not work as it cuts off most of the script.
I saved the script and opened it in SSMS. T...
Error Inserting Text
When trying to synchronize a table with a text column, the following code is generated:/*
Script created by SQL Data Compare version 7.2.0.3 from Red Gate Software Ltd at 6/1/2009 10:33:38 AM
Note...