Microsoft SQL Server and SQLEditor

Can I use SQLEditor with a Microsoft SQL Server database?

Yes, but with some limitations.

SQLEditor has support for importing from SQL Server with JDBC.
It has a specific dialect for exporting and some ability to import from files.
SQLEditor will also auto-detect Microsoft SQL Server JDBC drivers when they are installed.

Export to Database. SQLEditor should be able to export new objects but may have difficulty updating existing objects
Import from SQL. This has difficulty with some of the SQL dialect, in particular the GO keyword.

Yes. Work is progressing on improvements and version 2.7.2 should include better support for SQLServer.

The SQL Server JDBC driver is available directly from Microsoft at their website.

Currently the SQL Server 2005 JDBC Driver 3.0 is recommended

Other versions may also work.

If you are offered a choice of download versions we suggest choosing the Unix rather than Windows version. (Because it easier to extract)

The unix edition is provided as tar.gz file and can be easily decompressed.

The archive contains a folder called enu which should contain a jar file called sqljdbc4.jar.

Copy the file sqljdbc4.jar file to /Library/Java/Extensions/.

SQLEditor should find these drivers automatically when it starts up.

If SQLEditor is already running you may need to restart it to see the new drivers.