Database Url for sql server

General Discussion
1

I use next comand to run liquibase with sql server 2008R2:


liquibase.bat --classpath={} --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver –url={?} 

–changeLogFile=$changeLogFile update


My question is: what is the right url format

I tried  jdbc:sqlserver://localhost/dbname - Possibly the wrong driver for the given database URL error

          jdbc:sqlserver://localhost{;}databaseName=dbname - Unexpected value }databaseName: parameters must start with                                                                                           a ‘–’ error

          jdbc:sqlserver://localhost\sqlexpress/dbname - Possibly the wrong driver for the given database URL error


But I didn’t get success wih any of them

Thanks for answers

2

This works for us:


jdbc:jtds:sqlserver://localhost:1433/DEV;instance=SQLEXPRESS


DEV = db name