Activity overview
Latest activity by MelissaOlson
schema compare and queue tables and queues
Hi,
Is there a way to set up my schema compare so that it will find my queues and queue tables?
Thanks!
I'd love to hear about any luck you had finding a tool as well. We are just beginning our MySQL implementation and will have a need to compare to SVN as well. / comments
I'd love to hear about any luck you had finding a tool as well. We are just beginning our MySQL implementation and will have a need to compare to SVN as well.
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 / comments
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 ab...
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 [image] / comments
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 sa...
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! / comments
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 comma...