Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow

Support > Technical Documents > Document Types > White Paper-Technical > Migrating a PostgreSQL Database to SQL Anywhere 12

Migrating a PostgreSQL Database to SQL Anywhere 12
RSS Feed

Migrating data from PostgreSQL to SQL Anywhere can be a straightforward process if there are not a lot of PostgreSQL extensions in use within your database and application. SQL Anywhere simplifies migration by including built-in tools that facilitate a smooth transition from PostgreSQL (and other RDBMS’s) to SQL Anywhere.

The first part of this document discusses in detail differences between SQL Anywhere and PostgreSQL, including data type differences, feature differences, and syntax differences. Some of the features that are unique to PostgreSQL can hinder migration. Approaches to how you might choose to deal with these issues are provided. The second part of this document includes a systematic explanation of how to migrate data from a PostgreSQL database into a SQL Anywhere database using the Sybase Central Data Migration wizard. Finally, the third part of this document supplies an example of how you might migrate an existing application running against PostgreSQL to one that runs against SQL Anywhere.

This document was written for SQL Anywhere version 12 and later, and PostgreSQL version 9.1 and later.

Click here to download the whitepaper.



Last Revised: Jul 13, 2012
Product: SQL Anywhere, SQL Anywhere OnDemand
Technical Topics: SQL Anywhere, Data Migration, Database Admin
Business or Technical: Technical
Content Id: 1098823
Infotype: White Paper-Technical

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics