Command Line interface

n3xus

Is there anyway I can automate the deployment?

I can't care less about security, consistency or any other side effects.

Michael Christofides

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

MelissaOlson

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!

Michael Christofides

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

MelissaOlson

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

Michael Christofides

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

MelissaOlson

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