Needles Migrations: Database Conversions

Needles Migrations: Database Conversions

Because the Needles database is an Advantage database, special steps need to be taken to access and convert it.

On the Needles Server

Backup the Needles Database

Connect to the Needles Database server.

Stop the SQL Anywhere - Needles service.

Copy the Needles.db file to your Migration Workstation (it is generally located at C:\Needles\Needles.db)

Start the SQL Anywhere - Needles service.

On your Migration Workstation

Install SAP Sybase SQL Anywhere

Go to this URL:

https://www.sap.com/products/technology-platform/sql-anywhere/trial.html

And download SQL Anywhere for your OS.  You will have to create a free account and log in to download.

Alternatively, you can also use this direct download link:

https://d5d4ifzqzkhwt.cloudfront.net/sqla17developer/bin/SQLA17Developer.exe

 

Run the Database Server

Now you need to run the database server and start your database.

Run the database server application:

  1. C:\Program Files\SQL Anywhere 17\Bin64\dbsrv17.exe

And choose your database file and click OK:

Once you do, you'll temporarily see a log window and then the application will minimize itself to the System Tray.  Find the icon in the system tray and double-click it.

When it appears, search the log and find the database name and port number:



Connect Using Full Convert

Using Full Convert, you can now connect to the database with the following settings:

  1. Database Engine: Sybase SQL Anywhere (ASA)
  2. Host:            localhost:2638      (Replace '2638' with your port number from above)
  3. Username:        dba                 (Yes, the username is 'dba')
  4. Password:        sql                 (Yes, the password is 'sql')
  5. Server Name:     <BLANK>             (No server name should be specified)
  6. Database Name:   Needles             (Replace 'Needles' with your database name from above)

You will now be able to convert the data to SQL Server.


    • Related Articles

    • Needles Migrations: Backing up a Needles database

      Because the Needles database is an Advantage database, special steps need to be taken to access and convert it. In this article we will... Copy the Needles database from the Needles server Install and run SAP Sybase SQL Anywhere on your migration ...

    • Prevail Backups: Database Conversions

      Converting the Database Prevail uses an object-oriented database named Postgres. Recover your username and password to Postgres Refer to the Training: POSTGRES - Recovering username/pw article for instructions on preparing your database for ...

    • Amicus Accounting: Database Conversions

      Because Amicus Accounting uses the FoxPro database engine, it must be converted before you can use it. When you receive an Amicus Accounting backup, it will be a ZIP file with content like this: You should extract the ZIP file and then locate the ...

    • Abacus: Database Conversions

      When working with Abacus, the database must first be converted into MSSQL format. Abacus from Sybase Advantage Abacus uses an old database format named Sybase Advantage. Before performing the conversion, you will need to gain access to the data. This ...

    • Proclaim Backups: Database Conversions

      Proclaim runs using the Progress OpenEdge database engine. You should contact Proclaim to have them enable ODBC connectivity and the use Full Convert to convert the database from ODBC to SQL. When you do, errors will occur but they can be ignored.