Red Gate forums :: View topic - Script Size Limitation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Script Size Limitation

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
StanG



Joined: 30 Nov 2012
Posts: 2
Location: Melbourne AUS

PostPosted: Fri Nov 30, 2012 4:43 am    Post subject: Script Size Limitation Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Fri Nov 30, 2012 12:28 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
StanG



Joined: 30 Nov 2012
Posts: 2
Location: Melbourne AUS

PostPosted: Mon Dec 10, 2012 12:31 am    Post subject: Script Size Limitation Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Mon Dec 10, 2012 8:19 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Tue Dec 11, 2012 8:57 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group