Spectral Core Full Convert Enterprise v18.11.1502 » Developer Team :: Best choice for developers!

Spectral Core Full Convert Enterprise v18.11.1502

Spectral Core Full Convert Enterprise v18.11.1502
Spectral Core Full Convert Enterprise v18.11.1502


Full Convert is the easiest way to convert your database. Whether you need to simply copy your data over or have sophisticated customization needs, you have come to the right place. All popular databases are supported. A high-speed database converter carefully engineered to efficiently handle even the largest databases.

Source databases
Access
Amazon RDS
CSV
IBM DB2
dBase
Apache Derby
Excel
Filemaker
Firebird
Greenplum
Gupta SQLBase
H2
HSQLDB
Ingres
Interbase
MariaDB
MySQL
NexusDB
Oracle
Paradox
Pervasive
PostgreSQL
Progress OpenEdge
QuickBooks
SQL Script (*.sql file)
SQL Azure
SQL Server
SQL CE
SQL Express LocalDB
SQLite
Sybase ASA
Sybase ASE
Sybase Advantage
Vertica
VistaDB
Visual FoxPro
...and many more via ODBC

Target databases
Access
Amazon RDS
CSV
IBM DB2
dBase
Apache Derby
Excel
Firebird
Gupta SQLBase
Greenplum
H2
HSQLDB
Ingres
Interbase
MySQL
NexusDB
Oracle
Pervasive
PostgreSQL
Progress OpenEdge
SQL Azure
SQL Server
SQL CE
SQL Express LocalDB
SQLite
Sybase ASA
Sybase ASE
Vertica
VistaDB
Visual FoxPro
...and many more via ODBC

Full Convert will quickly and easily copy your data from source to the target database. It will create all the tables, copy all of your data, then create indexes and foreign keys.

Our software is designed to shield you from complexity of underlying databases. While you have powerful mapping and customization features at your disposal, your data will be migrated out of the box with no customization needed.

Full Convert automatically adjusts to your databases and uses optimal copying mode for each table separately to achieve the best possible throughput.

Note: Full Convert is not designed to migrate views, stored procedures, functions and triggers. Use our SQLTran for that.

Migrating from your old database? We got you covered.

We support modern relational databases. We support ancient file databases. For over 30 of most popular you need absolutely no drivers - just select your database and you are good to go.

Even if you use a mainframe database, we support standard (if slow) ODBC standard, so our software will be able to work with your database server.

Here is an example of converting a 3 billion record SQL Server table to PostgreSQL.

With a fast target database such as Postgres, we achieve a million records per second throughput! Full Convert was using just 68MB of memory, as it streams data very efficiently from source to target.

Speed of your conversion will vary depending on databases you use, network lag, table structure and other factors.

Having many thousands of tables in source and needing to convert just a few? No problem, as you can use our instant filtering to quicky display only certain tables.

You can even toggle selection on just tables selecting your filter.

Database errors can be very cryptic and it's often hard, even for seasoned database professionals, to know what is going on - not to mention someone who is not an expert and just wants to move to another database.

Our software consults our online error database when you have trouble connecting to database. We created helpful hints for stuff you may encounter.

Full Convert is written in philosophy of making everything easy for the user. For example, you don't have to manually create target database in your database manager prior to conversion.

If you don't have your target database created, Full Convert will ask you if you'd like it to create it for you. It will then proceed to copy all of your source database data into it right away.

Inspect logs later and examine exactly what happened during conversion in detail.

Summary log - overview of conversion
Error log - list of errors encountered (if any)
SQL log - all SQL statements executed on target database during conversion
SQL Error log - only the SQL statements resulting in error when executed on target

When you need recurring conversion (typically, people run them overnight), use our built-in scheduler to easily set up conversions to run unattended. Our scheduler can trigger your conversions to run:

Every N minutes
Every day at exact time
On certain days in week
On a specific day of the month
Once at a specific date and time

When you want to tweak conversion details for specific table, use table mapping screen and change everything!

Rename the table, rename its columns, deselect some columns...
Change datatypes and their precisin, edit default values...
Convert only a subset of records using custom WHERE clause
Tell for specific tables that you don't want them created and expect target to exist
Map source table to another table in target database

Set up schema mapping, datatype mapping and default value mapping at once for all tables.

This allows you to create custom rules for everything and tweak only specifics in table mapping screens.

Set up rules for schema handling (i.e. map JOHN in source to JILL in target, everything else to PUBLIC)
Change precision of certain data types, change other types completely
Using complex functions in source database that have no equivalent in target? Specify exactly what to do.

v18.11.1502 November 9, 2018 at 10:12:09

- Fixed reading of certain Teradata datatypes

v18.11.1501 November 8, 2018 at 12:22:14

- Fixed QuickBooks metadata reading

v18.11.1500 November 7, 2018 at 21:10:09

- Fixed parsing of MySQL 3.23 metadata

v18.11.1499 November 7, 2018 at 10:14:30

- Clarified wording on offline activation screen

v18.10.1498 October 29, 2018 at 12:38:47

- Fixed handling of very old Postgres servers

v18.10.1497 October 25, 2018 at 11:08:12

- Fixed handling of DB2 bigint type

v18.10.1496 October 23, 2018 at 13:30:01

- Added reading of referential actions from Sybase SQL Anywhere

v18.10.1495 October 22, 2018 at 12:43:51

- Fixed index type parsing in Sybase SQL Anywhere
- Improved analysis of default values in Sybase SQL Anywhere

v18.10.1494 October 19, 2018 at 21:22:09

- Improved handling of BOOLEAN types in SIARD

v18.10.1493 October 19, 2018 at 06:45:24

- Added Teradata support
- Fixed reading meta-data for MySQL

v18.10.1492 October 16, 2018 at 13:01:34

- Fixed handling of certain NexusDB table column default values

v18.10.1491 October 16, 2018 at 12:38:47

- Changed MySQL database provider to provide compatibility with all MySQL Servers versions (3.23 and later)

v18.10.1490 October 12, 2018 at 13:57:17

- Sybase Advantage database support rewritten to use Advantage Server
- Fixed NexusDB list of reserved words
- Removed exclusive lock on log files during the conversion time, so they can be inspected while conversion is still running


Only for V.I.P
Warning! You are not allowed to view this text.


Information
Users of Guests are not allowed to comment this publication.