Copying APS data from one database to another

Crystal Enterprise enables you to copy the contents of one APS database into another database. This procedure is also referred to as migrating an APS database. You can migrate APS data from a different APS database (version 8.0 or 8.5 of Crystal Enterprise) into your current APS database. Or, you can migrate the data from your current APS database into a different data source.

Note:    Throughout these procedures, the source APS database refers to the data that you are copying; this data is copied into the destination database. The destination database is initialized before the new data is copied in, so any existing contents of the destination database are permanently deleted (all Crystal Enterprise tables are destroyed permanently and then recreated). Once the data has been copied, the destination database is established as the current database for the APS.

To copy APS data from a different APS database (version 8.0 or 8.5 of Crystal Enterprise) into your current APS database, follow the procedure that corresponds to your operating system and to the version of Crystal Enterprise whose data you want to copy. In this scenario, your current APS database is the destination database whose tables are deleted before they are replaced with the copied data:

• Copying data from a Crystal Enterprise 8.5 APS on Windows
• Copying data from a Crystal Enterprise 8 APS on Windows
• Copying data from a Crystal Enterprise 8.5 APS on UNIX

To copy the current APS database from one database server to another, follow the procedure that corresponds to your operating system. This is also the procedure to follow if you want to move the default APS database (on Windows) from the Microsoft Database Engine (MSDE) to a dedicated database server, such as Microsoft SQL Server or Oracle. In this scenario, your current APS database is the source environment. Its contents are copied to the destination database, which is then established as the active database for the APS:

• Copying data from a Crystal Enterprise 8.5 APS on Windows
• Copying data from a Crystal Enterprise 8 APS on Windows

Before starting these procedures, ensure that you have a database user account with Create, Delete, and Update rights to the database storing the Crystal Enterprise tables. Ensure also that you can connect to both databases—through your database client software or through ODBC, according to your configuration—from the APS machine whose database you are replacing.

Note:    

• When you copy data from one database to another, the destination database is initialized before the new data is copied in. Thus, any existing contents of the destination database are permanently deleted. (If the APS database is stored in Oracle, all the Crystal Enterprise tables are deleted.)
• Back up both APS databases before beginning this procedure. If necessary, contact your database administrator.
• When you migrate an APS database, none of the objects on the system (report objects, report instances, folders, and so on) are actually moved. If you want to import users, groups, folders, and reports from one system to another, see Importing with the Crystal Import Wizard.