---
title: "SQLOne - SQL Converter for many DB Dialects?"
url: "https://osherove.com/blog/2006/5/18/sqlone-sql-converter-for-many-db-dialects.md"
canonical: "https://osherove.com/blog/2006/5/18/sqlone-sql-converter-for-many-db-dialects.html"
published: "2006-05-18T06:23:00"
updated: "2006-05-18T06:23:00"
tags: ["Cool Tools"]
author: "Roy Osherove"
description: "SQLOne looks like a good idea: \" SQLOne Console 3.0 - Automatic SQL conversion utility to translate SQL queries between the dialects used by Oracle, SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL, and pure ANSI…"
usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)."
license: "https://creativecommons.org/licenses/by/4.0/"
---

# SQLOne - SQL Converter for many DB Dialects?

By Roy Osherove May 18, 2006 In [Cool Tools](https://osherove.com/blog/category/cool-tools)

**Historical article** · Originally published May 18, 2006; technical details may be outdated.

SQLOne looks like a good idea:

"[SQLOne Console 3.0](http://www.swissql.com/products/sql-translator/sql-converter.html) - Automatic SQL conversion utility to translate SQL queries between the dialects used by Oracle, SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL, and pure ANSI SQL. Looks very useful indeed if you need to support multiple back ends. [Trial version](http://www.swissql.com/products/sql-translator/sqlone-consolejava-downloadform.html) is limited to converting 50 queries, contact them for pricing. "

\[via [Larkware](http://www.larkware.com/dg5/TheDailyGrind883.html)\]

Though the "contact them for pricing" seems a bit scary. That usually means something costs **a lot**.

PS

I use a question mark at the end of titles when :

a. I talk about something that I haven't checked out myself yet.

b. My title is a question.

## More in Cool Tools

[All posts in Cool Tools](https://osherove.com/blog/category/cool-tools)

- Jun 11, 2006

    ### [\[Cool Tool\] ASP.NET Enterprise Manager on Steroids: Ajax, Multiple DB types, And open source!](https://osherove.com/blog/2006/6/11/cool-tool-aspnet-enterprise-manager-on-steroids-ajax-multipl.html)

- May 22, 2006

    ### [\[Cool Tool\] Free Intellisense for SQL Query Analyzer!](https://osherove.com/blog/2006/5/22/cool-tool-free-intellisense-for-sql-query-analyzer.html)

- May 16, 2006

    ### [Cool Freeware: Visual Task Tips](https://osherove.com/blog/2006/5/16/cool-freeware-visual-task-tips.html)

- May 15, 2006

    ### [Review: SmartInspect - Logging for .NET, Java and Delphi](https://osherove.com/blog/2006/5/15/review-smartinspect-logging-for-net-java-and-delphi.html)


---

## About the author

**Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery.

### Sites

- [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership.
- [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts.
- [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin.
- [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model.
- [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps.
- [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes).

### Social

- X: https://x.com/royosherove
- LinkedIn: https://www.linkedin.com/in/osherove/

### Contact

- Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7

### License

Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/