May 12, 2014

Spotfire Migration steps


Migrate an Information Model to point to a new database We now have quite a few customers who are actively trying to migrate from a Test Spotfire Server to a Production Spotfire Server. The issue is that in many cases they want the Data Source on Test to point to \\test-database and they want a Data Source with the same GUID on Production to point to \\production-database . These instructions are for Spotfire Server 3.0 only and require separate Test and Production servers of Spotfire Server (SS). Start with a Data Source (DS), Information Elements (IEs), an Information Link (IL) and DXP file that uses that IL on the Test Spotfire Server (TSS). DS points to \\test-database and is in a different SS folder that the IEs, IL or DXP file. Export the folder on the Test SS that contains the DS Import that folder on to the Production SS, choosing the option to maintain GUIDs Modify DS on the Production SS so the connect string points to \\production-database After this step do not migrate the DS again to the Production DSS Export the folder on the Test SS that contains the IEs, IL and DXP file Import that folder on to the Production SS When you open the DXP file from the Production SS Library it should connect to DS through the \\production-database http://spotfirecommunity.tibco.com/community/blogs/stn/archive/2009/12/03/migrate-an-information-model-to-point-to-a-new-database.aspx