Existing Script compatibility

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Existing Script compatibility

Postby craig » Thu Oct 18, 2012 7:59 pm

Hello All,

I tried to compare a script to an existing schema, but the tool complained that the scripts had not been created by it.

I have a "ton" of pre-existing scripts. Is there a way to bypass this complaint or import/convert them so that the tool will use them?
Thanks,

Craig
craig
 
Posts: 1
Joined: Thu Oct 18, 2012 7:48 pm
Location: Little Elm, TX USA

Postby neil.anderson » Wed Oct 24, 2012 8:49 am

Hi Craig,

Thanks for trying out the beta scripts folder functionality in Schema Compare.

For the time being we do not support pre-existing scripts. Given the complexity of Oracle DDL, we are focusing on understanding the syntax that Schema Compare outputs and ironing out any issues there first.

Are your existing scripts created by hand? by a previous version of Schema Compare? or something else?

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Latest status on existing scripts compatibility

Postby northtexasranch » Wed Apr 24, 2013 6:44 pm

I recently downloaded v3.0 of Schema Compare for Oracle and I not only have existing DDL files that I would like to compare against, but also I rely on generating DDL from our data modeling tool. When I used to have a SQL Server target, using Schema Compare (for SQL Server) against DDL generated by that same tool worked like a charm, so I was hoping for the same experience on Oracle.
northtexasranch
 
Posts: 3
Joined: Wed May 16, 2007 7:17 pm

Postby Michael Christofides » Thu Apr 25, 2013 10:30 am

Thank you for the comments. As you've noticed, this isn't supported, but there is a workaround that works in some cases. It depends on the current format of the files you have, but normally involves rearranging folder structures (to match ours) and adding empty xml files in specific places. If you're interested in trying it out let us know and we'll happily work through it with you.
Michael Christofides
 
Posts: 95
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Re: Workaround

Postby northtexasranch » Thu Apr 25, 2013 11:39 pm

Yes, I would like to hear about any workarounds that I could try!

Michael Christofides wrote:Thank you for the comments. As you've noticed, this isn't supported, but there is a workaround that works in some cases. It depends on the current format of the files you have, but normally involves rearranging folder structures (to match ours) and adding empty xml files in specific places. If you're interested in trying it out let us know and we'll happily work through it with you.
northtexasranch
 
Posts: 3
Joined: Wed May 16, 2007 7:17 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests