Red Gate forums :: View topic - Data compare output SQL file - DECLARE sections
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

Data compare output SQL file - DECLARE sections

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



Joined: 03 Jul 2014
Posts: 7

PostPosted: Thu Jul 24, 2014 8:39 pm    Post subject: Data compare output SQL file - DECLARE sections Reply with quote

Hi, when the SQL script file is produced for a data compare, you get the typical, eg:

DECLARE
null_value CHAR(#) := NULL;
statement1 CHAR(#);
BEGIN
statement1 := 'some statement'
EXECUTE IMMEDIATE statement1 USING 'some values'
END;

1. How can I make each DECLARE section only be for one table, as it sometimes contains more than one.

2. How do I limit the number of statements included for execution in the DECLARE section. Seems to be currently limited to around 160 and I want to make it less.

3. Is there a way to output multiple SQL files instead of one large one?

Thanks, Andrew
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Fri Jul 25, 2014 10:55 am    Post subject: Reply with quote

Thank you for your forum post.

By default, the deployment script is enclosed in a single transaction.

There is an option in the Tools menu ->Application Options ->General Tab, that may help you to split the transactions.

At the bottom of the General Tab there is an option that is turned off by default 'Split transactions/batch operations' and then you set the 'maximum transaction/batch size' which by default is set to 10MB.

There are no options within the product to create multiple deployment scripts. The way around would reduce the number of tables and views whose data you wish to deploy. Create the deployment script. Return to the Comparison Results panel ->deselect the tables you just created the deployment script for and select the next table or tables to create the deployment script upon ->run the deployment wizard to create the deployment for this set of tables. Repeat as required until you have generated the required number of deployment scripts.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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