SAP SQL Anywhere

SAP SQL Anywhere (Sybase SQL Anywhere, Sybase ASA)

SAP SQL Anywhere is a relational database management system from SAP. It was known as Sybase SQL Anywhere until SAP Acquired Sybase. Originally 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 be also used as a database server for small and medium businesses. SQL Anywhere scales from embedded database engine to thousands of users in client/server mode.

Full Convert supports SAP SQL Anywhere database directly.

SAP SQL Anywhere data types we support

Integral

bigint, integer, smallint, tinyint, unsigned bigint, unsigned int, unsigned smallint, unsigned tinyint

Decimal

decimal (numeric), double, float (real)

Text

char, long nvarchar, long varchar (text), nchar, nvarchar, varchar

Binary

binary, bit, varbinary (long varbit)

Date/Time

date, datetime, time, timestamp (timestamp with time zone)

Large objects

long binary, long nvarchar, long varchar (text), xml

Other

uniqueidentifier

Export SAP SQL Anywhere database

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