ODBC

ODBC

ODBC is not a database - ODBC stands for Open Database Connectivity and is a standard interface for accessing databases. Most database engines have their own ODBC driver to allow for standardized access to their database.

It is generally independent from database systems and operating systems, so in theory an application running on one database and accessing it via ODBC should be able to run on another ODBC-enabled database with no changes. Of course, that's rarely the case, but ODBC does significantly simplify work with different database systems.

Standardized access, of course, brings its downsides. Each database has its own strength and deviates from standard (more or less) to take advantage of its unique strengths. Using ODBC generally means using lowest-common denominator in features. If you use a costly database system, you generally want to use it to its fullest. Using ODBC means crippling performance, as ODBC driver has to translate all database calls and results between native database structures and standard ODBC ones.

All our products fully support ODBC. However, for all cases where we support your database directly (natively), use our direct database engine instead of ODBC. We work very hard to support all the peculiarities of each database and give you best possible performance and stability. ODBC layer is always one more layer where things can go wrong and not all ODBC drivers are of highest quality.

ODBC data types we support

Integral

bigint, int, smallint, tinyint, ubigint, usmallint

Decimal

decimal (numeric), double, money, real

Text

char, nchar, ntext, nvarchar (sysname), text (clob, long varchar), varchar (longvar)

Binary

binary, bit, varbinary

Date/Time

date, datetime, time, timestamp

Large objects

blob (longvarbinary, long binary, long varbinary), ntext, text (clob, long varchar), xml

Other

hierarchyid, uniqueidentifier

Export ODBC database

It may make sense to migrate your data away from ODBC. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current ODBC database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.