Documentation
SQL Server
Use bulk insert
Standard SQL inserts are a slow way to fill in data to the table. Microsoft SQL Server allows for a much faster way and Full Convert takes advantage of this mode. Text file of predefined structure is built during conversion, allowing SQL Server to parse it at much greater speed, bypassing indexes and standard SQL parsing. Indexes and constraints are created afterwards. Speedups compared to standard inserts are often tenfold.
By default this option is enabled only if conversion is made on the machine where server is installed. If you have a network folder exposed at the server machine, you can specify it here. Speedups are not so drastic in this case as data has to travel through the network.
Note: bulk insert is automatically disabled when either SQL Logging is enabled, table contains BLOB fields, or when Table Settings are used.
Interpret dates in years 0000-0099 as 1900-1999
To be used when you have a legacy data with partial years.
Misc
Parse views as tables - sometimes you have access only to a certain view, not to full table. Use this option in that case.
- Full Convert
- Buy now!
- Download free trial
- Features
- Screenshots
- Testimonials
- Version history
- Tutorials
- Video tutorials
- Online help
Introduction- Overview
- How to buy?
- Versions
- Quick start
- Interface
- Session wizard
- Convert
- Interface tour
- Interface overview
- Session wizard
- Overview
- Source database
- Target database
- Tables selection
- Table settings
- Summary
- Menu
- Toolbar
- Database structure tree
- Table data grid
- Options dialog
- Conversion summary
- Summary
- Error log
- SQL log
- Scheduler
- Welcome Dialog
- Connecting to databases
- Access
- DBF (dBase and FoxPro)
- Excel
- Interbase/Firebird
- Lotus 1-2-3
- MySQL
- ODBC
- Oracle
- Paradox
- SQL Server
- Text
- XML
- Actions
- Column editor
- Modify data
- Extract to new table
- Create referencing column
- Execute SQL statement
- Options
- General
- Conversion
- Transform
- SQL Server
- MySQL
- Oracle
- DBF (dBase or FoxPro)
- ODBC
- Text
- Interbase/Firebird
- Advanced
- Session settings
- Command line
- Session overrides
- History
- Version history
August 18, 2010
Full Convert 5.7 released
To see detailed version history of this application, click here.
We have used Full Convert Enterprise Software by Spectral Core for a number of data conversion projects, mainly from DBF/Paradox tables to both SQL Server and mySQL.
The software has greatly reduced the time and effort required to convert the data. When we came across a problem with the conversion of one DBF table to SQL Server, Spectral Core's support was fantastic: they responded almost immediately, took a copy of our problem data and within a day had identified a minor issue with Full Convert. They then issued an upgrade which has cured the problem.
Our investment of $299 in the software has already been recouped in the time saved on data conversion. I would recommend this product to anyone involved in data conversion and I would highly recommend the speedy service and professionalism of the Spectral Core support team.
