QAID # 11655 Published
Question / Problem:
When migrating the standard database to SQL Server using DBUtil, the following error is being generated:
schema not empty.
Is there a tool that can be used to determine if the database is truly empty?
Answer / Solution:
When migrating the standard database to SQL Server, Kofax Capture requires that the database be empty of objects.
The database schema is the database structure described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables. A schema object is a logical data storage structure, such as tables, indexes, clusters, etc. A schema is a collection of schema objects, and a schema is associated with each database user. The schema associated with the default logon user that is creating the database must be empty of objects for Kofax Capture to be able to migrate to it.
The following SQL query will determine if objects exist in the database:
SELECT COUNT(*) FROM sysobjects WHERE category = 0
If no objects exist, the statement should return 0.
In this statement, the category column with a value of 0 represents normal database objects, so if there are no objects in the database, the statement should return a result of 0.