Open topic with navigation

Database Conversion

Use this migration tool if:

• You need to move from one database type to another (for example, from Oracle to SQL Server)
• You need to move from an unsupported database version (for example, from SQLServer 2000 to SQLServer2005)

Review status in the CommonSpot 6.0 Compatible column, select the appropriate data source, and click the Migrate button in the Action column. Review "System Requirements" in the CommonSpot Installation Guide for compatibility information.

The Migration tool prompts for database type. Select the database running on the target server and click Next.

The Data Source Information dialog displays. Complete the following fields:

• Database Name: Required. Enter the name of the new database.
• Database Server: Required. Enter the IP address or host name of the database server.
• Port: Required. Enter the port for accessing the database server.
• Database User ID: Required. Enter a unique user name to access the database.
• Note: This user name cannot be shared with any other CommonSpot data sources.
• Database Password: Required. Enter the password associated with the above user ID.
• ColdFusion Administrator Password: The ColdFusion password supporting this instance of CommonSpot.

Click Migrate to select the new database type.

 

Related Links

Database Migration Choose Database Type

Database Migration Datasource Information

---

You can download PDF versions of the Content Contributor's, Administrator's, and Elements Reference documents from the support section of paperthin.com (requires login).

The following guides are available from the support site and are in the /docs/directory of your CommonSpot Server:

• Getting Started Guide
• Upgrade Guide
• Release Notes

You can also download these other guides from the support section of paperthin.com (with login):

• Developer's Guide
• Template Developer's Guide
• Shared Database Configuration Guide
• Replication vs Shared Database Guide 

Sites upgrading from versions earlier than release 6.0 should review the following (from the support section of paperthin.com - requires login):

• What's New in CommonSpot 6.0
• CommonSpot 6.0.0 Menu Quick Reference

---

For technical support:

http://www.paperthin.com/support/

Open topic with navigation