Hi,
I want to copy a sqlserver database to a new one by generate changelog from existing database and update the new one with this. But I get following error:
- SEVERE 21.02.13 15:46:liquibase: Error executing SQL CREATE TABLE [dbo].[allinone] ([wert_refid] INT NOT NULL, [wert_typ] SMALLINT NOT NULL, [wert_id] VARCHAR(25) NOT NULL, [wert_text] VARCHAR(40), [wert_text01] VARCHAR(40), [wert_text07] VARCHAR(40), [wert_text33] VARCHAR(40), [wert_text39] VARCHAR(40), [wert_text41] VARCHAR(40), [wert_text42] VARCHAR(40), [akt_flag] SMALLINT, [ab_date] VARCHAR(15), [bis_date] VARCHAR(15), [v_refid] INT, [fibu_id] VARCHAR(25), [change_flag] SMALLINT, [arc_refid] INT CONSTRAINT DF_allinone_arc_refid DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [mand_ref] INT CONSTRAINT DF_allinone_mand_ref DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [kz_system] SMALLINT, [modification_date] VARCHAR(15), [modification_user] VARCHAR(10), CONSTRAINT [PK__allinone__BB1F89BB0F975522] PRIMARY KEY ([wert_refid])): Falsche Syntax in der Nähe des CREATE-Schlüsselworts.
liquibase.exception.MigrationFailedException: Migration failed for change set changelog_destdb.xml::1361455953899-7::otto (generated):
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[allinone] ([wert_refid] INT NOT NULL, [wert_typ] SMALLINT NOT NULL, [wert_id] VARCHAR(25) NOT NULL, [wert_text] VARCHAR(40), [wert_text01] VARCHAR(40), [wert_text07] VARCHAR(40), [wert_text33] VARCHAR(40), [wert_text39] VARCHAR(40), [wert_text41] VARCHAR(40), [wert_text42] VARCHAR(40), [akt_flag] SMALLINT, [ab_date] VARCHAR(15), [bis_date] VARCHAR(15), [v_refid] INT, [fibu_id] VARCHAR(25), [change_flag] SMALLINT, [arc_refid] INT CONSTRAINT DF_allinone_arc_refid DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [mand_ref] INT CONSTRAINT DF_allinone_mand_ref DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [kz_system] SMALLINT, [modification_date] VARCHAR(15), [modification_user] VARCHAR(10), CONSTRAINT [PK__allinone__BB1F89BB0F975522] PRIMARY KEY ([wert_refid])): Falsche Syntax in der Nähe des CREATE-Schlüsselworts.:
Caused By: Error executing SQL CREATE TABLE [dbo].[allinone] ([wert_refid] INT NOT NULL, [wert_typ] SMALLINT NOT NULL, [wert_id] VARCHAR(25) NOT NULL, [wert_text] VARCHAR(40), [wert_text01] VARCHAR(40), [wert_text07] VARCHAR(40), [wert_text33] VARCHAR(40), [wert_text39] VARCHAR(40), [wert_text41] VARCHAR(40), [wert_text42] VARCHAR(40), [akt_flag] SMALLINT, [ab_date] VARCHAR(15), [bis_date] VARCHAR(15), [v_refid] INT, [fibu_id] VARCHAR(25), [change_flag] SMALLINT, [arc_refid] INT CONSTRAINT DF_allinone_arc_refid DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [mand_ref] INT CONSTRAINT DF_allinone_mand_ref DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [kz_system] SMALLINT, [modification_date] VARCHAR(15), [modification_user] VARCHAR(10), CONSTRAINT [PK__allinone__BB1F89BB0F975522] PRIMARY KEY ([wert_refid])): Falsche Syntax in der Nähe des CREATE-Schlüsselworts.:
Caused By: Falsche Syntax in der Nähe des CREATE-Schlüsselworts.
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:114)
at liquibase.integration.commandline.Main.doMigration(Main.java:825)
at liquibase.integration.commandline.Main.main(Main.java:134)
Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[allinone] ([wert_refid] INT NOT NULL, [wert_typ] SMALLINT NOT NULL, [wert_id] VARCHAR(25) NOT NULL, [wert_text] VARCHAR(40), [wert_text01] VARCHAR(40), [wert_text07] VARCHAR(40), [wert_text33] VARCHAR(40), [wert_text39] VARCHAR(40), [wert_text41] VARCHAR(40), [wert_text42] VARCHAR(40), [akt_flag] SMALLINT, [ab_date] VARCHAR(15), [bis_date] VARCHAR(15), [v_refid] INT, [fibu_id] VARCHAR(25), [change_flag] SMALLINT, [arc_refid] INT CONSTRAINT DF_allinone_arc_refid DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [mand_ref] INT CONSTRAINT DF_allinone_mand_ref DEFAULT CREATE DEFAULT ZERO
AS 0 NOT NULL, [kz_system] SMALLINT, [modification_date] VARCHAR(15), [modification_user] VARCHAR(10), CONSTRAINT [PK__allinone__BB1F89BB0F975522] PRIMARY KEY ([wert_refid])): Falsche Syntax in der Nähe des CREATE-Schlüsselworts.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
… 5 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Falsche Syntax in der Nähe des CREATE-Schlüsselworts.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
… 9 more
the changeSet looks like this:
Has someone an idea?
kind regards,
Frank