Steps to migrate your database from ASA to SQL Server 2008 Express

Date:20 January 2010
Product/Release:Visual LANSA V11 & V12
Abstract:Steps to migrate your development database from V11 and ASA to V12 and SQL Server 2008 Express
Submitted By:LANSA Technical Support

Prior to V12, Adaptive Server Anywhere (ASA) was shipped with Visual LANSA as the default development database. Visual LANSA V12 ships SQL Server 2008 Express as the default development database. Download the following document, which details the following conversions:

  • Steps for the conversion of an existing Sybase ASA 9.0.2 Visual LANSA development database to a SQL Server 2008 Express database
  • Steps for the conversion of an existing Sybase ASA 9.0.2 Visual LANSA development database to a Sybase SQL Anywhere 11.0.1 database

A new template is also available which will assist in moving file data from one development environment to another. This template should be downloaded and unzipped to the x_win95\x_lansa\x_pkgs\x_tmplt folder under the LANSA root directory. Usage instructions are in the V12 Database upgrade instructions document.