[Liquibase-user] liquibase: database schema and data contents changeLog

2009-02-25 Thread Pradnya Gawade
Hi, I am new to liquibase and need some help. I want to get the database state with schema and database contents into a chageLog xml file. I want to use this xml at some other place to replicate the exact original database. I could get the database schema with 'generateChangeLog' command but I do

Re: [Liquibase-user] liquibase: database schema and data contents changeLog

2009-02-25 Thread Pradnya Gawade
n the generated xml. I'm not sure what the > argument is for the jar file though. I can't find that in my command > history or in the jar help text. > > Ben > > Pradnya Gawade wrote: > > Hi, > > > > I am new to liquibase and need some help. > >

Re: [Liquibase-user] liquibase: database schema and data contentschangeLog

2009-02-25 Thread Pradnya Gawade
n < nvoxl...@intelligentinsites.com> wrote: > > If you run "liquibase --help" it will give you the options available from the command line. There should be a --diffTypes option or something similar. > Nathan > > > > On Feb 25, 2009, at 6:11 PM, "Pradnya Gawade

Re: [Liquibase-user] liquibase: database schema and data contentschangeLog

2009-02-26 Thread Pradnya Gawade
dnya* * On Wed, Feb 25, 2009 at 9:04 PM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > If you run "liquibase --help" it will give you the options available from > the command line. There should be a --diffTypes option or something > similar. > >

Re: [Liquibase-user] liquibase: database schema and datacontentschangeLog

2009-02-26 Thread Pradnya Gawade
t; --diffTypes=’data,tables,columns,views,primaryKeys,uniqueConstraints,indexes,foreignKeys,sequences’ > > Nathan > > > > *From:* Pradnya Gawade [mailto:pradnya.gawa...@gmail.com] > *Sent:* Thursday, February 26, 2009 12:26 PM > *To:* liquibase-user@lists.sourceforge.net >

[Liquibase-user] Liquibase: Custon sql with tag

2009-02-26 Thread Pradnya Gawade
Hi, I have a query about implementing Custon sql with tag in the liquibase changeLog xml file. I have to add some CREATE FUNCTION sql code in the tag. It has multilined sql statements and I am not successful in excecuting the same. I am not very clear with the line and statement separators insid

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-26 Thread Pradnya Gawade
line sql by using the splitStatements=”false” > attribute > > > > Nathan > > > > *From:* Pradnya Gawade [mailto:pradnya.gawa...@gmail.com] > *Sent:* Thursday, February 26, 2009 5:07 PM > *To:* liquibase-user@lists.sourceforge.net > *Subject:* [Liquibase-user] Liqui

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-27 Thread Pradnya Gawade
of elements must consist of well-formed character data or markup. at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java :78) at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:28) at liquibase.Liquibase.update(Liquibase.java:105) at

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-27 Thread Pradnya Gawade
; confuses the XML parser. You need to wrap it in a CDATA section: “ at the beginning, “]]>“ at the end. You’ll also need to add the > splitStatements=”false” attribute to the tag. > > > > Nathan > > > > > > *From:* Pradnya Gawade [mailto:pradnya.gawa...@gmail.

[Liquibase-user] liquibase: specify schema name specific to database

2009-03-03 Thread Pradnya Gawade
Hi, I am trying to have a common changeLog xml file for two databases Postgres and Oracle. Probably I have found the way to manage all other database specific syntax in the xml file except the schema names. I want to have different schema name for oracle and postgres as 'schemaName' attribute insi

Re: [Liquibase-user] liquibase: specify schema name specific to database

2009-03-06 Thread Pradnya Gawade
y. > http://www.liquibase.org/manual/changelog_parameters > > > > You can make your changeset as schemaName=”${schema}” and then pass the > schema you want into liquibase. > > > > Nathan > > > > *From:* Pradnya Gawade [mailto:pradnya.gawa...@gmail.co

[Liquibase-user] Oracle execute procedure problem

2011-08-30 Thread Pradnya Gawade
Hi, I am trying to create a procedure and run it on oracle 10g database. The procedure gets created successfully but never gets executed. Because I can see the procedure listed under Procedures through the SQL developer but do not see the expected tables updated which is done inside procedure. If

[Liquibase-user] Oracle execute procedure problem

2011-08-30 Thread Pradnya Gawade
Hi, Please excuse me if I am sending it twice as because of the network issue, I am not sure the one I sent couple of seconds back got posted or not. I am trying to create a procedure and run it on oracle 10g database. The procedure gets created successfully but never gets executed. Because I can