generateChangeLog don't identify different schemas, just "dbo" (MSSQL 2008)

General Discussion
1

You might try setting logLevel=DEBUG in you liquibase.properties file to get a better idea what liquibase is doing in this case. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

2

Hello!

I’m studying using liquibase in our project. We have a database in SQL Server 2008, with 2 schemas and this schemas are different from “dbo”.

When I test the generateChangeLog in a database with schema “dbo”, just the objects inside this schema are created in the changelog file.

But, when I try in our project database, no record is created.

3

Tnks in reply Steve!

I tried what you say, and I got the query executed. Tnks!

But now, I saw that it only runs for only one schema.

Now, I have two questions:

  1. How can I generate to all my schemas?
  2. How can I put the schema name in my changelog?

Thanks again!

4

Liquibase is designed to manage a single schema at a time, so you would probably need to generate changelogs for each of the schemas separately. According to my quick search results, the best way to do that is to have different users.

http://stackoverflow.com/questions/5509865/how-to-specify-schema-for-sql-server-in-jdbc-spring-configuration

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/