Command Line interface

Compares and synchronizes Oracle data

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

Command Line interface

Postby n3xus » Mon Jun 04, 2012 4:36 am

Is there anyway I can automate the deployment?

I can't care less about security, consistency or any other side effects.
n3xus
 
Posts: 6
Joined: Mon May 14, 2012 6:48 am

Postby Michael Christofides » Mon Oct 29, 2012 5:42 pm

Sorry for the ridiculously late reply, your message appears to have fallen completely under our radar.

There is some information about how to use the Data Compare for Oracle command line here:

http://www.red-gate.com/supportcenter/C ... o_using_cl

I'm monitoring this now so please post any questions below or email us on oracle@red-gate.com
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby MelissaOlson » Fri Apr 26, 2013 5:24 pm

Hi there,
I've looked through the help and have used the command line to generate a script to be used later but now I need to deploy that script. Is there a way to deploy the script from the command line without having the project do the compare again?
Thanks!
MelissaOlson
 
Posts: 5
Joined: Thu Apr 25, 2013 10:03 pm

Postby Michael Christofides » Fri Apr 26, 2013 5:46 pm

Hi Melissa,

Once you have the script saved (it's just a .sql script) you could use your editor from the command line to run it, for example:
http://serverfault.com/questions/87035/ ... and-prompt

Would that work for you?

Best regards,
Michael
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby MelissaOlson » Fri Apr 26, 2013 6:04 pm

I tried that but the script is inserting data that is so large it runs into sqlplus' limitation of 2499 characters per line. I tried opening the file in word as suggested by the oracle site and saving it as a text file with cr/lf but then sqlplus couldn't read it due to the cr/lf special characters. I also tried just cr and just lf but neither of those worked either. I've also tried the sql ant task but the way the script is generated from the tool sql can not consume it...I found that out while working with the .sql generated by the schema compare. I followed several sites that directed me to switch out the ";" or "/" end of file markers with no success so the schema compare I had to go the sqlplus route but for the data I can't seem to get it working...it's been a bit of a long road :wink:
MelissaOlson
 
Posts: 5
Joined: Thu Apr 25, 2013 10:03 pm

Postby Michael Christofides » Fri Apr 26, 2013 7:14 pm

Ah yes, ok.

There are several suggested solutions to that issue posted here:
https://forums.oracle.com/forums/thread ... ID=2217135

If the script is <50mb I'd probably try SQL Developer, else would any of the other solutions suit?

Regards,
Michael
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby MelissaOlson » Fri Apr 26, 2013 8:06 pm

This is for continuous integration and all handled through an ant file so that coupled with the size of the files will prevent me from doing anything manually. Our schema with just 2 tables and about 20,000 rows of data is hitting close to the 50mb size so all of our other schemas will be well over this.

I don't know sql *loader yet but it looks like it expects a csv file...I'll look at this next.

I may be going at this the wrong way...after building my schema from the schema compare maybe I can use a flashpoint or some type of back up to get the data back in there.

Thanks,
Melissa
MelissaOlson
 
Posts: 5
Joined: Thu Apr 25, 2013 10:03 pm


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests