Script Size Limitation
StanG
Posts: 3
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.
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
Stan
Comments
- 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.
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.
Stan
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)?