New Topic: upgrade existing db project 1.9 => 2.0

[Nathan Voxland-3]

A new topic, 'upgrade existing db project 1.9 => 2.0', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=153.new#new

The text of the topic is shown below:

Hi,
definitely I skipped a how-to upgrade existing 1.9 project to version 2.0
Code:
Trying to launch 2.0 over 1.9 database liquibase throws exception (launched under maven 2.2.0)

...trunkmischung-dbupdatemischung>mvn package
[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Building Update Mischung db
[INFO]    task-segment: [package]
[INFO] ------------------------------------------------------------------------
[INFO] [resources:resources {execution: default-resources}]
[WARNING] Using platform encoding (Cp1252 actually) to copy filtered resources, i.e. build is platform dependent!
[INFO] Copying 52 resources
[INFO] [compiler:compile {execution: default-compile}]
[INFO] Nothing to compile - all classes are up to date
[INFO] [liquibase:updateSQL {execution: generate-step}]
[INFO] ------------------------------------------------------------------------
[INFO] there are no resolved artifacts for the Maven project.
[INFO] Output SQL Migration File: C:devreckittMischungAppltrunkmischung-dbupdatemischungtargetliquibasemigrate.sql
[INFO] Executing on Database: jdbc:jtds:sqlserver://localhost:1433;DatabaseName=mischung
18.09.2009 12:23:59 liquibase.logging.JavaUtilLogger info
INFO: Successfully acquired change log lock
18.09.2009 12:23:59 liquibase.logging.JavaUtilLogger warning
WARNUNG: C:/dev/reckitt/MischungAppl/trunk/mischung-dbupdate/mischung/target/classes/changeset-mischung.xml is using schema version 1.9 rather than version 2.0
18.09.2009 12:24:00 liquibase.logging.JavaUtilLogger info
INFO: Reading from [dbo].[DATABASECHANGELOG]
18.09.2009 12:24:00 liquibase.logging.JavaUtilLogger info
INFO: Successfully released change log lock
18.09.2009 12:24:00 liquibase.logging.JavaUtilLogger info
INFO: Successfully released change log lock
18.09.2009 12:24:00 liquibase.logging.JavaUtilLogger info
INFO: Successfully released change log lock
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Error setting up or running Liquibase: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG FROM [dbo].[DATABASECHANGELOG] ORDER B
Y DATEEXECUTED ASC, ORDEREXECUTED ASC

Invalid column name 'ORDEREXECUTED'.
[INFO] ------------------------------------------------------------------------
[INFO] For more information, run Maven with the -e switch
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3 seconds
[INFO] Finished at: Fri Sep 18 12:24:00 GMT+01:00 2009
[INFO] Final Memory: 8M/15M
[INFO] ------------------------------------------------------------------------


It would be nice to be pointed how to troubleshoot the issue .

Cheers, Oleg

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user