Optional Schema Name in synch saved script files

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

Optional Schema Name in synch saved script files

Postby lee.andrews » Fri Feb 26, 2010 12:02 pm

Hi there,

Just another feature enhancement request. When synchronising to a script it would be useful to have the option not to have the the schema/user name included in the script. E.g Create Table "SCHEMA"."MYTABLE" is what is created now but capability to switch this off so would output Create Table "MYTABLE"

Not a major one as can do a find and replace to make the synch script more generic but a nice to have.

Regards,

Lee.
lee.andrews
 
Posts: 6
Joined: Thu Feb 25, 2010 4:34 pm
Location: Midlands, UK

Postby Simon C » Fri Feb 26, 2010 12:34 pm

May I ask what the use case of this feature is? When would you not want the schema to be specified?
Simon C
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software

Postby lee.andrews » Mon Mar 01, 2010 11:36 am

Hi Simon,

We have many environments including several development, testing, staging and live environments.

These environments get installed with different user names/schemas so the ability to compare and make the generated script more generic by not including the schemas name is useful to us and can subsequently be used to upgrade/downgrade many of these different environments with the same script without having to manually change the schema name across environments.

It's not a major feature but more of a nice to have.

Hope this helps.

Lee.
lee.andrews
 
Posts: 6
Joined: Thu Feb 25, 2010 4:34 pm
Location: Midlands, UK

Postby alice.easey » Mon Mar 01, 2010 2:09 pm

Hi Lee,

I've added this request to our backlog as OC-152 - I can see how it would help to create more generic scripts.

We're trying to tie down the features for v1 now, so I'm afraid I can't guarantee that this will make it in for v1. Customer requests always add weight to a feature request though, so thanks for raising it.

Thanks for all your feedback so far - please let us know if you have any further comments, feature requests, or issues.

Thanks,

Alice.
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby lee.andrews » Mon Mar 01, 2010 3:49 pm

Hi Alice,

Thanks for that, it certainly would be a most helpful and useful enhancement for us.

Regards,

Lee.
lee.andrews
 
Posts: 6
Joined: Thu Feb 25, 2010 4:34 pm
Location: Midlands, UK


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests