Data compare output SQL file - DECLARE sections

Compares and synchronizes SQL database content.

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

Data compare output SQL file - DECLARE sections

Postby planetawylie » Thu Jul 24, 2014 8:39 pm

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
planetawylie
 
Posts: 7
Joined: Thu Jul 03, 2014 9:09 pm

Postby eddie davis » Fri Jul 25, 2014 10:55 am

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests