Excel to Pervasive PSQL database conversion

Full Convert Full Convert

Excel to Pervasive PSQL database conversion

Here is how Full Convert Enterprise converts Excel database to Pervasive PSQL.

Source database is also known as Excel, Microsoft Excel (related files: xls, xlsx)

Target database is also known as Pervasive PSQL

First look at Full Convert

Welcome screen

The conversion of Excel to Pervasive PSQL database conversion using Full Convert is simple and has to do a few quick steps:

  • Connect to your source target databases
  • Optional: Choose which tables you want to convert (all are selected by default)
  • Start the conversion, sit back and enjoy
  • Optional: Explore your new data in the target database using a built-in database explorer

When we start Full Convert, you will notice a welcome panel with links for common tasks. Let"s start a new conversion.

Click the Create new conversion link or click the New button in the ribbon above.

Connection to source Excel database

Excel connection

Initial screen shows you that Full Convert will automatically detect your database if you don"t know which one do you have. Of course, if you do know your database, do select it from the list on the left.

We will choose Excel from the list of available database formats. Full Convert supports all versions of Excel documents from Excel 97 to Excel 2007. XLS and XLSX files are read flawlesly. Formulas will be calculated during the conversions, so target database will have formula results stored, not the formula expression texts.

Just type-in the folder containing your Excel documents, or click the ellipsis button on the right and Full Convert will display Browse for Folder dialog.

You don't even need to have Excel installed to be able to convert your Excel documents. We directly read your Excel files.

Connection to target Pervasive PSQL database

Pervasive PSQL connection

List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.

Table selection

Table selection

We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don"t need - or deselect all, then select just the tables you do need.

Review

Summary screen

Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.

Click the Convert! button to get started.

Conversion progress

Data copying from source to target

Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.

  • Running your custom pre-conversion SQL scripts, if any
  • Creating all selected tables in your target database
  • Copying data
  • Applying indexes
  • Applying foreign key constraints
  • Running your custom post-conversion SQL scripts, if any

Excel to Pervasive PSQL conversion summary

Conversion is completed

Here you will see basic conversion statistics, such as number of tables and records copied to target database.


If there were any warnings or errors during conversion, you will be able to examine them in detail.

Finally, complete SQL log is available for you if you need it. This feature can be enabled in project options screen.

Project overview
Target database browser

Conclusion

This small tutorial shows how easy it is to convert Excel to Pervasive PSQL using Full Convert Enterprise.

If you like what you see, please purchase Full Convert at our site. Delivery is instant via email, and with 30 day money-back guarantee there is no risk in purchasing.

Also, if you want to make sure our applications fits your needs before buying, you can download free trial version.

fullconvert
Full Convert Enterprise
  • Powerful database conversion
  • Install on up to 3 computers
  • Source: over 30 databases supported
  • Target: over 30 databases supported
  • Console application included
  • Extendable maintenance
  • Support by developers
  • 30 day money-back guarantee
  • Instant delivery
$699
includes 12 month maintenance
core suite
CORE SUITE SUBSCRIPTION
Monthly Yearly
  • ALL OUR TOP APPLICATIONS
  • fullconvert Full Convert Enterprise
  • replicator Replicator Pro
  • query Query Pro
  • documenter Documenter Pro
  • Up to 5 installations per application
  • 30 day money-back guarantee
  • Instant delivery
$
Standard license

When you purchase a standard license, your license is perpetual - it will never expire. One year of maintenance is included in price and you can install our product on up to 3 computers. Obsolete installations can be deactivated to free up installation on a new machine.

At any time you can log into our website with email used for purchase and see your licenses and invoices, as well as manage activated computers.

Subscription

When you purchase a subscription, you will be charged every month (monthly subscription) or every year (yearly subscription).

You get access to our 4 desktop products - Full Convert, Replicator, Query and Documenter. Each of these applications can be installed on up to 5 computers. As long as subscription is active, maintenance is active, so you have peace of mind knowing you can always upgrade and always contact technical support. However, as soon as you cancel the subscription, products will stop working (standard subscription model).

You should choose subscription if you use several of our applications or purchasing process in your company is cumbersome and getting approval for maintenance extension can take some effort.

Maintenance explained

Maintenance covers technical support and access to upgrades of the application. As long as your maintenance is active, you can log into our website and download the latest release.

You can extend your maintenance before it expires, or renew it up to 12 months after it expires. Extension is cheaper than renewal and therefore recommended. Subscriptions don't need maintenance extensions, as all subscribers have active maintenance for as long as they are subscribed.

Resellers

Resellers should contact us to obtain a discount.

Our customers range from micro-businesses to Fortune 500

Clients from over 90 countries love us! Here are some of them.

Our clients