SQL Anywhere

SQL Anywhere
Database background

SAP SQL Anywhere is a relational database management system from SAP. It was known as Sybase SQL Anywhere until SAP acquired Sybase. Originally the product was called Watcom SQL (created by Watcom International Corporation).

SQL Anywhere runs on many operating systems. Its database files are OS-agnostic and, like SQLite, can be copied to any platform and immediately be usable as databases. SQL Anywhere is well-suited as an embedded database. It’s used in Intuit QuickBooks, for example. It can also be used as a database server for small and medium businesses. SQL Anywhere scales from an embedded database engine to thousands of users in client/server mode.

SQL Anywhere data types we support

Integral:
bigintintegersmallinttinyintunsigned bigintunsigned intunsigned smallintunsigned tinyint
Decimal:
decimal (numeric)doublefloat (real)
Text:
charlong nvarcharlong varchar (text)ncharnvarcharvarchar
Binary:
binarybitvarbinary (long varbit)
Date/Time:
datedatetimetimetimestamp (timestamp with time zone)
Large objects:
long binarylong nvarcharlong varchar (text)xml
Other:
uniqueidentifier

Export SQL Anywhere Database

It may make sense to migrate your data away from SQL Anywhere. 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 SQL Anywhere 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.

Import data into SQL Anywhere Database

Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.

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