Ms sql native client 10

broken image
broken image

I believe the JDBC URL connection type exists as this is the default J2EE mechanism for connecting to a database.Any SQL Server sql script executed by Flyway, can be executed by Sqlcmd, SQL Server Management Studio and other SQL Server-compatible tools (after the placeholders have been replaced). DDL exported by SQL Server can be used unchanged in a Flyway migration. Standard SQL syntax with statement delimiter GO T-SQL Compatibility. I had managed to connect using windows authentication using a similar method to the post in the wiki, I just put the driver jar file and the associated dll in the same folder as the datacleaner.exe file and that worked fine. I am using Microsoft SQL Server JDBC Driver version 2.0 which is the one for SQL Server 2008.

broken image