|
|
 SQL Server Migration Assistant for Sybase ASEBrief DescriptionAutomates database migration from Sybase ASE to SQL Server 2005. On This PageQuick Details| File Name: | SSMA for Sybase_1.2.858.zip | | Version: | 1 | | Date Published: | 5/22/2007 | | Language: | English | | Download Size: | 3.6 MB | | Estimated Download Time: | 9 min 56K |
OverviewSQL Server Migration Assistant (SSMA) for Sybase ASE is a complete suite of tools that dramatically cuts the effort, cost, and risk of migrating from Sybase ASE database to SQL Server. SSMA automates almost every aspect of the migration process including assessment, schema and data migration, business logic conversion.
With SSMA, IT organizations now have the freedom to move to SQL Server and take advantage of SQL Server's exceptional security, scalability, developer productivity, and the industry’s lowest total cost of ownership.
SSMA for Sybase ASE consists of a client tool that you use to migrate ASE databases to SQL Server, and an extension pack that contains tables and stored procedures to support migration and functions that replace Sybase ASE system function usage in migrated databases.  Top of page
System Requirements- Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP; Windows XP Service Pack 2
Requirements for the SSMA for Sybase ASE client:
• WinZip
• Microsoft Windows Installer 3.1 or a later version
• The Microsoft .NET Framework version 2.0 or a later version. The .NET Framework version 2.0 is available on the SQL Server 2005 product media. You can also obtain it from the .NET Framework Developer Center.
• The J# redistributable package, which is also available from the .NET Framework Developer Center.
• The Sybase OLE DB provider and connectivity to the Sybase ASE database server that contains the databases you want to migrate. You can install providers from the Sybase ASE product media.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server 2005.
• 1 GB RAM.
Requirements for the SSMA for Sybase extension pack:
• SQL Server 2005
• Microsoft Windows Installer 3.1 or a later version
• The Sybase OLE DB provider or Sybase ADO.NET provider and connectivity to the Sybase ASE database server that contains the databases you want to migrate. You can install providers from the Sybase ASE product media.
Top of page InstructionsSSMA for Sybase ASE is packaged as a .zip file. After downloading ssma-for-sybase.zip, you will extract two MSI files: ssma-for-sybase-n.msi and ssma-for-sybase-ep-n.msi, where n is the build number.
Installing the SSMA for Sybase Client
1. Download ssma-for-sybase.zip.
2. Extract all files from the compressed file
Depending on the version of WinZip you have, you can either double-click the file, or right-click the file and select Extract All or Open in WinZip. Follow the instructions in the WinZip user interface to extract the files.
3. Double-click ssma-for-sybase-n.msi, where n is the build number.
4. On the Welcome page, click Next.
If you do not have the prerequisite Sybase OLE DB provider installed, a message will appear indicating that you must first install the providers. You can install the Sybase OLE DB provider from the Sybase ASE product media.
5. Read the license agreement. If you agree, select I accept the terms in the license agreement, and then click Next.
6. To install the client program and documentation, click Typical.
7. Click Install.
Installing the Extension Pack
Installing the extension pack creates a new database, sysdb, on the instance of SQL Server 2005. The extension pack adds tables, stored procedures, and user-defined functions.
1. If you have not already done so, extract all files from ssma-for-sybase zip.
Depending on the version of WinZip you have, you can either double-click the file, or right-click the file and select Extract All or Open in WinZip. Follow the instructions in the WinZip user interface to extract the files.
2. Copy ssma-for-sybase-ep-n.msi, where n is the build number, to the computer that hosts SQL Server 2005.
3. Double-click ssma-for-sybase-ep-n.msi.
4. On the Welcome page, click Next.
5. On the End User License Agreement page, read the license agreement. If you agree, select the I accept the terms in the license agreement check box, and then click Next.
6. On the Ready to Install page, click Next.
7. On the completion page, click Finish.
A new dialog box will appear, in which you select the instance of SQL Server for the extension pack installation.
8. Choose the instance of SQL Server 2005 where you will be migrating Sybase ASE data, and then click Next.
The default instance has the same name as the computer. Named instances will be followed by a backslash and the instance name (NamedInstance\InstanceName).
9. On the Connection Parameters page, select your preferred authentication method.
Windows Authentication will use your current Windows credentials to attempt to log on to the instance of SQL Server. If you select SQL Server Authentication, you must enter a SQL Server login name and password.
10. On the Manage Server page, select Install Utilities Database n, where n is the version number, and then click Next.
11. The sysdb database is now created, and the user-defined functions and stored procedures are created in that database.
12. To install the utilities to another instance of SQL Server, select Return to instances, and then click Next. Otherwise, click Exit to exit the wizard. Top of page Additional InformationLicensing
SSMA is a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience. Top of page Top of page What Others Are Downloading Top of page
|
