View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000321Database Workbench v6Meta Data Compare & Migrationpublic2012-04-13 15:292020-09-09 14:06
ReporterEduardo A Salgado Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
PlatformIntel x86 32 bitOSWindowsOS Version7 Pro
Summary0000321: Ability to create an update script with each statement on its own
DescriptionHave a suggestion for your fine product.

When doing database compare, the program suggests an update script. Excellent.

My suggestion is to make that script more verbose so it is more likely to run without exceptions.

For example:
{code}
ALTER TABLE CICLIENTADVERTISER
  ADD EQUIVCODE VARCHAR( 10) COLLATE NONE
,
  ALTER TRAFFICID TYPE VarChar(38)
  , ALTER CFCODE1 TYPE VarChar(38)
  , ALTER CFCODE2 TYPE VarChar(38)
;
{/code}

May not run because the TrafficID, for example, is contained in a stored procedure. So, if one ignores, the ADD does not "take" nor the other ALTER. Or one may have to ABORT the entire script.

So I suggest you make it more verbose like:
{code}
ALTER TABLE CICLIENTADVERTISER ADD EQUIVCODE VARCHAR( 10) COLLATE NONE;
ALTER TABLE CICLIENTADVERTISER ALTER TRAFFICID TYPE VarChar(38);
ALTER TABLE CICLIENTADVERTISER ALTER CFCODE1 TYPE VarChar(38);
ALTER TABLE CICLIENTADVERTISER ALTER CFCODE2 TYPE VarChar(38);
{/code}

So, one can take note of which statement to "ignore" and then go back and work with that/those few.

In some cases there may be several ADD together with some ALTER and it slows down the process.

Just a suggestion.

Thanks for listening.
TagsNo tags attached.

Activities

Patrick Moloney

2012-05-02 20:53

reporter   ~0000082

This might make it easier to identify what the dependency is.
I'm not sure how much that will help, but perhaps a small help.

Issue History

Date Modified Username Field Change
2012-04-13 15:29 Eduardo A Salgado New Issue
2012-04-16 10:37 Martijn Tonies Status new => acknowledged
2012-05-02 20:53 Patrick Moloney Note Added: 0000082
2012-11-05 11:30 Martijn Tonies Summary Suggestion for Compare Module in DBWorkBench Pro 4 => Ability to create an update script with each statement on its own
2019-12-03 08:49 Martijn Tonies Project Database Workbench v4 => Database Workbench v6
2019-12-03 08:49 Martijn Tonies Category Compare & Migration => @1@
2020-09-09 14:06 Martijn Tonies Category @1@ => Meta Data Compare & Migration