Chapter 6
Upgrading

[p]This chapter includes instructions for upgrading from an earlier version of Lasso Professional. The first section contains instructions for upgrading from any version of Lasso Professional 8 or 8.5. The remainder of the chapter discusses upgrading from Lasso Professional 7 or earlier. [/p]

• Upgrading Lasso Professional 8 or 8.5 includes instructions for upgrading an existing Lasso Professional 8 or 8.5 installation to the most recent version.
• Overview includes information about what has changed in Lasso Professional Server and basic upgrade instructions.
• Upgrading on Mac OS X includes instructions for upgrading from Lasso Professional 5, 6, or 7 on Mac OS X.
• Upgrading on Windows includes instructions for upgrading from Lasso Professional 5, 6, or 7 on Windows 2000, Windows 2003 Server, or Windows XP Professional.
• Upgrading on Linux includes instructions for upgrading Lasso on Red Hat Enterprise Linux 4.
• Upgrading From Earlier Versions includes some notes about upgrading from earlier versions of Lasso Web Data Engine.

[note][b]Note: [/b]Please consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/note]

Upgrading Lasso Professional 8 or 8.5

[p]Installation of Lasso Professional 8 or 8.5 can be upgraded according to the instruction in the installation chapters of this setup guide. [/p]

• [def]Mac OS X[/def] – The Lasso Professional 8.5 installer can be used to install Lasso over the top of a previous installation of Lasso Professional 8 or 8.5. No extra steps are required.
• [def]Windows[/def] – The previous installation of Lasso Professional 8.5 should be uninstalled prior to installing the new version. The previous version can be uninstalled by using the [code]Remove[/code] option which is shown when launching the Lasso Professional 8.5 installer or by using the Add/Remove Programs control panel. No database or settings files will be removed by this procedure.
• Linux – The Lasso Professional 8.5 installer can be used to install Lasso over the top of a previous installation of Lasso Professional 8 or 8.5. No extra steps are required.

Overview

[p]Lasso 8.5 includes many new features which are detailed in the About Lasso 8.5 chapter in this guide. The following list includes some important new and changed features to consider when upgrading from a previous version of Lasso. [/p]

• [def]Backward Compatibility[/def] – Every attempt has been made to ensure 100% backward compatibility with developer-created solutions from Lasso Professional 7 or 8. No syntax modifications should be required to run Lasso Professional 7 or 8 code in Lasso Professional Server. See the Upgrading section in the Lasso 8.5 Language Guide for full details
• [def]SQLite[/def] – The internal data source in Lasso Professional Server has been changed to SQLite. Lasso MySQL is no longer supported. This means that any solution specific databases that were hosted in Lasso MySQL need to be migrated to an external installation of MySQL. Also, any solutions that relied on manipulating the internal security databases directly need to be updated for SQLite compatibility.
• [def]Multi-Site Architecture[/def] – The new multi-site architecture of Lasso Professional Server has required modifications to the built-in tools such as Lasso Administration (now Server and Site Administration). Details about how to access these tools in Lasso Professional Server are included later in this guide.

[p]The migration to SQLite and to the multi-site architecture require some manual steps in order to upgrade an existing Lasso Professional 5, 6, or 7 installation to Lasso Professional Server with all settings intact. [/p]

[note][b]Note: [/b]Please consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/note]

[p]The basic upgrade procedure (elaborated on in the platform-specific sections that follow) is as follows. Note that several of the steps can be performed well in advance of installing Lasso Professional Server in preparation of the upgrade. [/p]

To upgrade to Lasso Professional Server:

1. If solution databases are served from Lasso MySQL then an external installation of MySQL should be installed and the Lasso Settings Migrator used to move the databases from Lasso MySQL to the external installation.

2. The Lasso Settings Migrator should be used to export the settings from Lasso Professional 5, 6, or 7. The resulting text file will be imported into Lasso Professional Server.

[note][b]Important: [/b]The preceding steps can be performed at any time prior to installing Lasso Professional Server. These steps cannot be performed once Lasso Professional Server has been installed. [/note]

3. It is always recommended to make a full backup of the previous installation of Lasso. On Windows, the previous installation of Lasso must be uninstalled before Lasso Professional Server can be installed.

4. Install Lasso Professional Server and initialize with the serial number, server administration username and password, and SMTP settings. When prompted, select the exported settings file to set server settings and default site settings.

5. Install any additional modules, LassoApps, startup items, or JDBC drivers that were installed in the previous installation of Lasso. It may be necessary to restart the default site in order for Lasso to load these items.

6. Test each solution to ensure that they are accessing their data sources successfully and that all of their code is working properly. Although we strive for full backward compatibility it is essential that all upgraded solutions be tested thoroughly to ensure proper operation.

[p]These procedures are covered in more detail in the platform-specific sections that follow. The final section in this chapter includes notes about upgrading from earlier versions of Lasso Web Data Engine. [/p]

[note][b]Note: [/b]Please consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/note]

Upgrading on Mac OS X

[p]This section includes detailed instructions for upgrading from Lasso Professional 5, 6, or 7 to Lasso Professional Server on Mac OS X. Some of the steps in this procedure must be performed prior to installing Lasso Professional Server. For details about upgrading from earlier versions of Lasso Web Data Engine consult the final section in this chapter. [/p]

Preparation

[p]These steps can be performed at any time prior to installing Lasso Professional Server. However, these steps cannot be easily performed once Lasso Professional Server has been installed. [/p]

[p]If solution databases are served from Lasso MySQL then an external installation of MySQL should be installed and the Lasso Settings Migrator used to move the databases from Lasso MySQL to the external installation. The settings form Lasso Professional 5, 6, or 7 should be exported to a text file for import into Lasso Professional Server. [/p]

To migrate databases to an external installation of MySQL:

1. Download the latest version of MySQL from MySQL AB. There is a binary installation option for Mac OS X. Consult the licensing information to see if a commercial license of MySQL is required.

[pre]http://www.mysql.com/ [/pre]

2. Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to migrate any solution-specific databases from Lasso MySQL to the external installation of MySQL.
3. [note][b]Note: [/b]Using the Lasso Settings Migrator should not necessitate any changes to the solution hosted in Lasso Professional 5, 6, or 7. The migration to an external installation of MySQL can happen well in advance of installing Lasso Professional Server and can yield speed and feature benefits. [/note]

To export settings from Lasso Professional 5, 6, or 7:

[p]Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to export all of the settings from Lasso Professional 5, 6, or 7 into a text-based format that Lasso Professional Server can understand. [/p]

[p]This text file will be required in the Installation and Configuration section below once Lasso Professional Server has been installed. The export can be performed at any time prior to installing Lasso Professional Server. [/p]

Backup

[p]It is always recommended to make a full backup of the previous installation of Lasso before performing any upgrades. [/p]

Installation and Configuration

[p]The following procedure should be followed to install and configure Lasso Professional Server. [/p]

To install Lasso Professional Server:

[p]Run the Lasso Professional Server installer. If necessary, customize the installation by choosing the appropriate Web server connector. Consult the Configuring on Mac OS X chapter for full details. [/p]

[p]The installer should automatically launch the Web browser with the Server Administration initialization interface. [/p]

To configure Lasso Professional Server:

1. Enter the Lasso Professional Server serial number and select a server administrator username and password. Continue to the next screen.

2. Set up the software update notification and SMTP server preferences. The SMTP preferences are not automatically imported from the prior installation.

3. Choose a site administration username and password and select the export file from the Lasso Professional 5, 6, or 7 installation to automatically import its settings into the default site.

4. Continue to the final screen then on to Server Administration or Site Administration to continue configuring Lasso Professional Server if desired.

5. Install any additional modules, LassoApps, startup items, or JDBC drivers that were installed in the previous installation of Lasso. It may be necessary to restart the default site in order for Lasso to load these items.

[p]Lasso Professional Server is now configured with all the settings from the Lasso Professional 5, 6, or 7 installation on the default site. No additional configuration should be necessary in order to run existing Lasso Professional 7 compatible Lasso pages on this server. Upgrades from Lasso Professional 5 or 6 may require some syntax changes. Consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/p]

Testing

[p]Test each solution to ensure that they are accessing their data sources successfully and that all of their code is working properly. Although we strive for full backward compatibility it is essential that all upgraded solutions be tested thoroughly to ensure proper operation. [/p]

Upgrading on Windows

[p]This section includes detailed instructions for upgrading from Lasso Professional 5, 6, or 7 to Lasso Professional Server on Windows 2000, Windows Server 2003, or Windows XP Professional. Some of the steps in this procedure must be performed prior to installing Lasso Professional Server. For details about upgrading from earlier versions of Lasso Web Data Engine consult the final section in this chapter. [/p]

Preparation

[p]These steps can be performed at any time prior to installing Lasso Professional Server. However, these steps cannot be easily performed once Lasso Professional Server has been installed. [/p]

[p]If solution databases are served from Lasso MySQL then an external installation of MySQL should be installed and the Lasso Settings Migrator used to move the databases from Lasso MySQL to the external installation. The settings form Lasso Professional 5, 6, or 7 should be exported to a text file for import into Lasso Professional Server. [/p]

To migrate databases to an external installation of MySQL:

1. Download the latest version of MySQL from MySQL AB. There is a binary installation option for Windows. Consult the licensing information to see if a commercial license of MySQL is required.

[pre]http://www.mysql.com/ [/pre]

2. Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to migrate any solution-specific databases from Lasso MySQL to the external installation of MySQL.
3. [note][b]Note: [/b]Using the Lasso Settings Migrator should not necessitate any changes to the solution hosted in Lasso Professional 5, 6, or 7. The migration to an external installation of MySQL can happen well in advance of installing Lasso Professional Server and can yield speed and feature benefits. [/note]

To export settings from Lasso Professional 5, 6, or 7:

[p]Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to export all of the settings from Lasso Professional 5, 6, or 7 into a text-based format that Lasso Professional Server can understand. [/p]

[p]This text file will be required in the Installation and Configuration section below once Lasso Professional Server has been installed. The export can be performed at any time prior to installing Lasso Professional Server. [/p]

Backup

[p]It is always recommended to make a full backup of the previous installation of Lasso before performing any upgrades. [/p]

Uninstall Previous Version

[p]It is necessary to uninstall the previous version of Lasso before installing Lasso Professional Server. This can be accomplished by launching the Lasso Professional 7 installer and choosing the remove option or using the Add or Remove Programs control panel. Uninstalling the previous version of Lasso Professional will not delete any of the settings databases or solution files. [/p]

Installation and Configuration

[p]The following procedure should be followed to install and configure Lasso Professional Server. [/p]

To install Lasso Professional Server:

[p]Run the Lasso Professional Server installer. If necessary, customize the installation by choosing the appropriate Web server connector. Consult the Configuring on Windows chapter for full details. [/p]

[p]The installer should automatically launch the Web browser with the Server Administration initialization interface. [/p]

To configure Lasso Professional Server:

1. Enter the Lasso Professional Server serial number and select a server administrator username and password. Continue to the next screen.

2. Set up the software update notification and SMTP server preferences. The SMTP preferences are not automatically imported from the prior installation.

3. Choose a site administration username and password and select the export file from the Lasso Professional 5, 6, or 7 installation to automatically import its settings into the default site.

4. Continue to the final screen then on to Server Administration or Site Administration to continue configuring Lasso Professional Server if desired.

5. Install any additional modules, LassoApps, startup items, or JDBC drivers that were installed in the previous installation of Lasso. It may be necessary to restart the default site in order for Lasso to load these items.

[p]Lasso Professional Server is now configured with all the settings from the Lasso Professional 5, 6, or 7 installation on the default site. No additional configuration should be necessary in order to run existing Lasso Professional 7 compatible Lasso pages on this server. Upgrades from Lasso Professional 5 or 6 may require some syntax changes. Consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/p]

Testing

[p]Test each solution to ensure that they are accessing their data sources successfully and that all of their code is working properly. Although we strive for full backward compatibility it is essential that all upgraded solutions be tested thoroughly to ensure proper operation. [/p]

Upgrading On Linux

[p]This section includes detailed instructions for upgrading from Lasso Professional 5, 6 or 7 to Lasso Professional Server on Linux. Some of the steps in this procedure must be performed prior to installing Lasso Professional Server. For details about upgrading from earlier versions of Lasso Web Data Engine consult the final section of this chapter. [/p]

Preparation

[p]These steps can be performed at any time prior to installing Lasso Professional Server. [/p]

[p]If solution databases are served from Lasso MySQL then an external installation of MySQL should be installed and the Lasso Settings Migrator used to move the databases from Lasso MySQL to the external installation. The settings form Lasso Professional 5, 6, or 7 should be exported to a text file for import into Lasso Professional Server. [/p]

To migrate databases to an external installation of MySQL:

1. Download the latest version of MySQL from MySQL AB. There is a binary installation option for Red Hat Enterprise Linux. Consult the licensing information to see if a commercial license of MySQL is required.

[pre]http://www.mysql.com/ [/pre]

2. Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to migrate any solution-specific databases from Lasso MySQL to the external installation of MySQL.
3. [note][b]Note: [/b]Using the Lasso Settings Migrator should not necessitate any changes to the solution hosted in Lasso Professional 5, 6, or 7. The migration to an external installation of MySQL can happen well in advance of installing Lasso Professional Server and can yield speed and feature benefits. [/note]

To export settings from Lasso Professional 5, 6, or 7:

[p]Follow the instructions in the Lasso Settings Migrator (included in the Lasso Professional Server download package) to export all of the settings from Lasso Professional 5, 6, or 7 into a text-based format that Lasso Professional Server can understand. [/p]

[p]This text file will be required in the Installation and Configuration section below once Lasso Professional Server has been installed. The export can be performed at any time prior to installing Lasso Professional Server. [/p]

Backup

[p]It is always recommended to make a full backup of the previous installation of Lasso before performing any upgrades. [/p]

Installation and Configuration

[p]The following procedure should be followed to install and configure Lasso Professional Server. [/p]

To install Lasso Professional Server:

[p]Run the Lasso Professional Server installer. If necessary, customize the installation by choosing the appropriate Web server connector. Consult the Configuring on Linux chapter for full details. [/p]

[p]The installer should automatically launch the Web browser with the Server Administration initialization interface. [/p]

To configure Lasso Professional Server:

1. Enter the Lasso Professional Server serial number and select a server administrator username and password. Continue to the next screen.

2. Set up the software update notification and SMTP server preferences. The SMTP preferences are not automatically imported from the prior installation.

3. Choose a site administration username and password and select the export file from the Lasso Professional 5, 6, or 7 installation to automatically import its settings into the default site.

4. Continue to the final screen then on to Server Administration or Site Administration to continue configuring Lasso Professional Server if desired.

5. Install any additional modules, LassoApps, startup items, or JDBC drivers that were installed in the previous installation of Lasso. It may be necessary to restart the default site in order for Lasso to load these items.

[p]Lasso Professional Server is now configured with all the settings from the Lasso Professional 5, 6, or 7 installation on the default site. No additional configuration should be necessary in order to run existing Lasso Professional 7 compatible Lasso pages on this server. Upgrades from Lasso Professional 5 or 6 may require some syntax changes. Consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version. [/p]

Testing

[p]Test each solution to ensure that they are accessing their data sources successfully and that all of their code is working properly. Although we strive for full backward compatibility it is essential that all upgraded solutions be tested thoroughly to ensure proper operation. [/p]

Upgrading From Earlier Versions

[p]Lasso Professional Server does not automatically support upgrading from Lasso Web Data Engine or earlier versions of Lasso. This section includes some notes which should help make upgrading easier. [/p]

• Record the access information for each data source configured in Lasso including the IP address, username, and password. This will make it easy to reconfigure the data source in Lasso Professional Server.
• Lasso Professional Server does not support ODBC data sources or the local, AppleScript connection to FileMaker Pro on Macintosh. Installations which rely on these data sources will need to migrate to JDBC or the remote data source for FileMaker Pro.
• Lasso Professional Server does not have a CDML compatibility module. The Lasso CDML Converter available from LassoSoft’s Web site can be used to convert CDML-based solutions to Lasso Professional Server Lasso syntax.
• Upgrades from Lasso Web Data Engine will require some syntax changes. Consult the Upgrading section of the Lasso 8.5 Language Guide for important information about changes to Lasso in this version and upgrade procedures.
• The Lasso Updater in Lasso Studio can be used to automatically update sites that use an earlier version of Lasso to Lasso Professional Server preferred syntax.