Upsizing a database to SQL Server

Existing iBase databases can be upsized from Access to SQL Server. The original Microsoft Access connection file is replaced with a connection file for SQL Server, but the content of the upsized database and text search indexes remains unchanged

About this task

Important: Upsizing a database is an irreversible operation.

Procedure

  1. Select Tools > Database Setup > Upsize > Database to SQL Server.

  2. In the first page of the wizard select the database.

  3. Enter a name for the backup file. If you do not want to create a backup to disk, delete the suggested name. Click Next.

  4. In the next page enter the SQL Server information and click Next.

    Note: Only select the (local) option from the Server drop-down list if the database is for personal use.

  5. Check the information in the third page and click Finish.As the database is upsized a list of operations is displayed. When the upsize is complete, scroll through this list and check that all values in the Status column are "Success". When you close list, iBase Designer opens the SQL Server database.

  6. Check that the settings in the Configuration and Advanced pages of the Database Properties dialog are as expected; they are for an SQL Server database.

  7. Close the database.

  8. Select Tools > Database Administration > Schema Integrity Check.

  9. Select the upsized database and complete each page of the wizard. When you have completed the wizard, the SQL Server database is opened and ready to use.