Using the User Guide database on SQL Server

The User Guide database is supplied as a Microsoft Access database. However, if you want to try out the features that are only available in SQL Server then you will need to ask your System Administrator to convert the database to SQL Server for you.

About this task

The following instructions are intended for a System Administrator, who will need permission to create a database on your SQL Server machine.

Procedure

  1. Check that the server does not have an existing database called User Guide. If it does, rename the User Guide.idb file, for example to User Guide 2.idb. You will also need to rename the other files associated with the database (with the suffixes .dot, .doc, .ant and .idx).
  2. Copy the User Guide Database folder to a suitable place. It is located in: C:\Program Files\i2 iBase <n>\Resources\<language>\Examples\User Guide Database
  3. Start iBase Designer, and then log on to the security file User Guide.ids as user SYSADMIN and cancel the option to open a database or create a new one.
  4. From the Tools menu, select Database Setup > Upsize > Database to SQL Server.
  5. Accept the option to make a backup.
  6. Enter the name of the SQL Server machine and a login and password that has the dbcreator role on the server. Do not use the server name (local) since other clients will not be able to use the database. This server name is intended only for local use on the server computer. If the database name does not appear when you refresh the list, type in the machine name of the server.
  7. Click Finish.
  8. In iBase Designer, use the appropriate search option on the Tools menu to build a search index. For further information, click Help in the appropriate search dialog.