1 Reply Latest reply on May 10, 2007 12:30 PM by britchie

    Can Internal database be migrated to external database?

      I was using the internal Clearspace database for evaluation. Now, after purchasing the product, I'd like to start using an external database (SQL Server). Is it possible to migrate the system to an external database without reinstalling the product? If so, how is this done - with simple step by step instructions.

        • Re: Can Internal database be migrated to external database?



          Yes, this is currently possible (though this may not always be the case in the future). The database schemas are currently identical between the two products though some configuration settings are different between the two products and a new license is required.


          Some differences I see with a quick look at the database schema are the profile fields are different, some permissions are different, private messages are enabled for Clearspace X, blog pings are enabled for Clearspace X and viewing of user's email addresses is disabled by default in Clearspace X.


          If you diff the database script for sql server between the two products you'll get an exact list of changes between the two versions and you can manually run the insert statements to modify the settings for the internal instance to make it an external instance.


          A few notes though:


          1. You'll of course want to backup the database prior to making any manual change

          2. You will be unable to use the same database for running both an internal instance and an external instance. It sounds like this won't be an issue for you however I wanted to make it clear for any other users that may read this thread.





          Bruce Ritchie