FrontBase Documentation

Backtrack:
  Welcome!
    4. Administering a FrontBase Server
      4.9. Backup and Restore
Updated: 20-Nov-2000
prev — next
Table of Contents

4.9.4. Importing from Sybase

FrontBase allows you to import content data from Sybase. Use the following SQL statement:

INSERT INTO <table-name> FROM 'Sybase' INPUT('<path name of file with content data>', '<path name of file with format data>');

The format of the two files must be as if generated by the bcp utility (supplied by Sybase).
A common issue for all import formats is that the schema must be properly defined before the import will work. The import filter is very unforgiving about incorrectly formatted input. Please experiment with a test database before working with a production database!

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!