# Liquibase error on copy sqlserver db **URL:** https://forum.liquibase.org/t/liquibase-error-on-copy-sqlserver-db/2196 **Category:** General Discussion **Created:** [February 21, 2013, 10:52pm UTC](https://forum.liquibase.org/t/liquibase-error-on-copy-sqlserver-db/2196 "2013-02-21T22:52:00Z") **Posts on this page:** 1 **Page:** 1
### Author: ![fpunktopunkt](https://avatars.discourse-cdn.com/v4/letter/f/0ea827/32.png) [@fpunktopunkt](https://forum.liquibase.org/u/fpunktopunkt) #### Post date: [February 21, 2013, 10:52pm UTC](https://forum.liquibase.org/t/liquibase-error-on-copy-sqlserver-db/2196/1 "2013-02-21T22:52:00Z")
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: 1. 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: 1.                                                                                                                                                                                                                                                                                                                                                                                                                             Has someone an idea? kind regards, Frank