Red Gate forums :: View topic - Existing Script compatibility
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Existing Script compatibility

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
craig



Joined: 18 Oct 2012
Posts: 1
Location: Little Elm, TX USA

PostPosted: Thu Oct 18, 2012 7:59 pm    Post subject: Existing Script compatibility Reply with quote

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
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Wed Oct 24, 2012 8:49 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
northtexasranch



Joined: 16 May 2007
Posts: 3

PostPosted: Wed Apr 24, 2013 6:44 pm    Post subject: Latest status on existing scripts compatibility Reply with quote

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.
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 90
Location: Red Gate Software

PostPosted: Thu Apr 25, 2013 10:30 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
northtexasranch



Joined: 16 May 2007
Posts: 3

PostPosted: Thu Apr 25, 2013 11:39 pm    Post subject: Re: Workaround Reply with quote

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.
Back to top
View user's profile Send private message
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