SQL Server example

General Discussion
1

What error are you getting and what version of liquibase are you using?

Nathan

2

Hi Steve,


I tried using generateChangeLog but I get a different error now. 


D:\Liquibase>java -jar liquibase.jar --changeLogFile=“D:\Liquibase\scripts\demo.txt” --diffTypes=“data” --url=jdbc:sqlserver://sql-ilp-test:1433;tempdb generateChangeLog

Liquibase generateChangeLog Failed: D:\Liquibase\LiquibaseDriverssqljdbc4.jar does not exist

SEVERE 4/28/14 11:07 AM:liquibase: D:\Liquibase\LiquibaseDriverssqljdbc4.jar does not exist

liquibase.exception.CommandLineParsingException: D:\Liquibase\LiquibaseDriverssqljdbc4.jar does not exist

        at liquibase.integration.commandline.Main.configureClassLoader(Main.java:668)

        at liquibase.integration.commandline.Main.main(Main.java:132)


Below are the steps I have done till now


  1. Created a Property file 


driver:com.microsoft.sqlserver.jdbc.SQLServerDriver 

classpath=“D:\Liquibase\Drivers\sqljdbc4.jar”

url=jdbc:sqlserver://sql-ilp-test:1433;tempdb 

username=test 

password=test 


  1. Have a folder to load generated script.


Question

-------------

  1. Which drive do you use to connect to SQL Database. 

  2. In my property file I have passed this url "Brijesh

3

Thanks for the help guys, it started working. Not is a matter of learning the commands and there usage. 

4

Hi, I am new to liquibase and helping my release team integrated this tool. Has anyone got an end example of liquibase for sql server? Like simple steps to create a table or insert statement ?


Thanks

5

Do this: run Liquibase generateChangelog on an existing SQL Server database. This will generate examples for you based on your own database. It’s pretty neat!


The cool thing about Liquibase is that it is platform agnostic. So, any examples at liquibase.org should be applicable to SQL Server.


Robert

6

Hi Robert,

java -jar  liquibase.jar

–driver: com.microsoft.sqlserver.jdbc.SQLServerDriver 

–classpath=sqljdbc4.jar 

–url=jdbc:sqlserver://sql-test:1433;tempdb 

–username=test 

–password=test 

–changeLogFile=D:\scripts\test.xml


i fails 

7

Hi Nathan,


I have created a liquibase.properties file and stored above properties in the same location as the Jar file Brijesh

8

Hi Nathan,


  1. Am I using the right class file ?

  2. Am I doing the right steps ?


I am using the latest version of the Liquibase. 


Thanks again,
Brijesh

9

It looks like you aren’t giving liquibase a command. 


It should be something like this:

No, Oracle client is not a prerequisite for SQL Server. 

10

I think the issue is how you are setting the classpath property. Rather than this:


http://www.datical.com/