Script Size Limitation

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Script Size Limitation

Postby StanG » Fri Nov 30, 2012 4:43 am

Hi,
SQL data Compare has identified that source table (SQL Server 2K8R2) needs to update the destination table (SQL server 2K8R2) with approx 29K records. None of the column data types are TEXT. One column with most data is VARCHAR(MAX).

When I select "Deploy using SQL Data Compare, I get an eror "data compare between text and varchar(max) is invalid". Note: there are no text data types in neither source nor destination database.

If I grab about 6 records from the script, and execute in SSMS it works OK. However if I grab 100 records up comes the error.

Any suggestion how I can get the data accross using SQL Data Compare will be appreciated.
Regards
Stan
StanG
 
Posts: 2
Joined: Fri Nov 30, 2012 4:08 am
Location: Melbourne AUS

Postby chriskelly » Fri Nov 30, 2012 12:28 pm

To try to figure out what is going wrong we are going to need to try to reproduce the error. Would it therefore be possible for you to send the following to support@red-gate.com and include the support ticket number F0067228 in the subject line.

- a schema creation script for both objects in the comparison
- confirmation of the exact version number of SQL Data Compare e.g. 9.50.0.237
- confirmation of the exact version number of SQL Server involved e.g. 10.50.0.7600
- a copy of the generated deployment script giving you the error. As I assume that this is rather large for an email I can supply an ftp account for it.

I am happy for you to send me a different object if you are uncomfortable sending me the one involved, but only if you are confident that it gives exactly the same behaviour.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Script Size Limitation

Postby StanG » Mon Dec 10, 2012 12:31 am

Chris,

It has been over a week since I provided you with the requested information to solve this issue. Do you have an ETA when I can expect a solution / reply. Many thanks for your assistance.
Regards
Stan
StanG
 
Posts: 2
Joined: Fri Nov 30, 2012 4:08 am
Location: Melbourne AUS

Postby chriskelly » Mon Dec 10, 2012 8:19 pm

I'm sorry for taking so long to get back to you.

I did receive the schema creation scripts etc and I have attempted to reproduce the problem. However, I have been unable to do so. Would it be possible for you to send me the output from your deployment (a screenshot should suffice)?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby chriskelly » Tue Dec 11, 2012 8:57 pm

Thank you for sending the additional info. I have just sent you an email asking for the tools error log file. Can you following the instructions and then send me the resulting .txt file that is generated.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests