Overview Replication Customer support
Tutorials Documentation Changelog Databases
Try it
Purchase
Blog
About us Contact
English Deutsch Português Italiano Français
Login
Overview Replication Customer support
Tutorials Documentation Changelog Databases
Try it
Purchase
Blog
About us Contact
English Deutsch Português Italiano Français

Overview

Introduction Quick start Activation

Project wizard

Wizard Source connection Target connection Table selection Wizard review

Project options

Project options General Naming Log files Mapping Run before conversion Run after conversion Databases Troubleshooting

Mapping tables

Automatic mapping Manual mapping Troubleshooting mappings

Global settings

Global settings Privacy

Scheduler

Scheduler Task editor

Console

Console application Usage Connection overrides

Database connections

Supported databases Access CSV DB2 DBF (Clipper, dBase, Visual FoxPro) Excel Firebird Derby H2 HSQLDB Interbase MySQL NexusDB ODBC Oracle Paradox Pervasive PSQL PostgreSQL Progress Azure SQL Database SQL Server Compact SQL Express LocalDB SQLite SQL Server Sybase SQL Anywhere Sybase Adaptive Server Enterprise VistaDB MariaDB Sybase Advantage Vertica Filemaker QuickBooks Gupta SQLBase

About projects

What is a project? Overview

Conversion process

Creating tables Copying data Creating indexes Creating foreign keys Conversion review

Quick start

Let's convert our database by clicking the New project button. It will open up a conversion project wizard. Once we go through wizard, we can run the conversion right away and have our target database ready to use.

We can also opt to save the project for later use. Such saved projects appear in the list of recent projects below and can be opened with a single click.

For this short tutorial, we will copy SQL Server's demo database Adventure Works to PostgreSQL. To convert our database, we will use the conversion wizard, which has 4 steps.

Page 1 of 4: Source database

We will select SQL Server from the list of supported databases.

Page 2 of 4: Target database

We will select PostgreSQL from the list of supported databases and fill in correct connection information. If target database doesn't exist, Full Convert will prompt you if you would like it to create it for you.

Page 3 of 4: Table selection

Page 4 of 4: Project review

Conversion

Conversion review

Browsing the data

Browsing in external tool

Of course, you can use database management application of your choice to examine target database.

Spectral Core

Independent software vendor specializing in database solutions.

Support

Documentation Customer support

Company

About Contact Blog

Legal

Privacy Legal & Policies

© 2024 Spectral Core Limited. All rights reserved.