Migration of GXportal .NET SQL2000 to 2008

To migrate a GXportal .NET installation whose DBMS is SQL Server 2000 to SQL Server 2008, follow the steps below:

Download the corresponding setup for this environment from here.

Follow the instructions provided in this installation manual.  Once it has been installed, upon accessing the backend you will not have any licenses because they will be transferred only after validating the migrated website.

IMPORTANT: The server in which SQL Server 2008 is installed must have Sun JVM 1.6 or higher installed. To verify this requirement you can run the following command on Windows: java -version.

Next, you have two options –either to open a backup of the entire database or make an import/export of the portal.

1. To make an import/export, download the corresponding applications for SQL2000 (export) and 2008 (import) from here.
2. To open the entire database, follow the steps below:
   1. We assume that you have a backup file called "dbdummybackup.bak" created with SQL 2000. Open SQL Server Management Studio 2008.
   2. Right-click on the gxportal database and select the option labeled Tasks – Restore Database.
   3. In the dialog box that is displayed, select the "From Device" option and look for the "dbdummybackup.bak" file in your disk.
   4. Select the check box of the backup file to be opened.
   5. From the menu on the left, choose the "Options" option, select the option labeled "Overwrite the existing database," and where it says "Restore As" make sure that both paths at the end read gxportal_Data.MDF and gxportal_Log.LDF.
   6. Confirm.
   7. After opening the database, run the following SQL query so that the gxportal user defined for that database takes the gxportal login defined in that SQL Server: Exec sp_change_users_login 'update_one', 'gxportal', 'gxportal'
   8. Lastly, copy the website’s image directory (C:\Inetpub\wwwroot\gxportal\gxpfiles\<sitio>), and in the new server where they will be hosted, set up the new multimedia paths in the backend.

To validate the website, you need to change the domain so that it points to the new server. Once it has been validated, transfer the licenses to the new server following the manual downloaded in step 2.