Bolte IT Consulting
Toggle Navigation
  • Home
  • Featured Articles
  • Tech Blog
    • Joomla CMS
    • Java SE / EE
      • JavaFX and e(fx)clipse
      • JAXB
      • Apache POI
      • Java SE
      • Java EE
    • HP ALM
      • HP ALM REST API
      • HP ALM Workflow VBScript
    • Useful Software
    • VB.NET
    • XML
    • Oracle Database
      • Oracle SQL
      • Oracle PL SQL
      • Oracle SQL Developer
    • VBA
      • Excel VBA
      • Access VBA
      • MS Office and VBA
      • Power Point VBA
    • MS SQL Server
    • Shortcuts
    • COBOL
    • SharePoint
    • SAP SQL Anywhere
  • Off Topic
  • About
    • Profil / Curriculum Vitae (CV) - English
    • Profil / Curriculum Vitae (CV) - German

Bolte IT Consulting

Java connect to SQL Anywhere database

So, ...  I like to try new things and since I had to migrate an old version of an SQL Anywhere database into an open source database, I thought I might as well do it the fun way.

I will write a little Java Spring Batch Applicaiton in order to move the data from SQL Anywhere into MariaDB in a professional way.

In this article you can learn how to connect your client to an SQL Anywhere database using Java.

Last Updated: 19 March 2020
Hits: 5584
  • SAP
  • SQL Anywhere
  • Database
  • Relational Database
  • SQL
  • Data Migration
  • Java

PL SQL for analyzing and rebuilding indexes

Recently I had to rebuild some indexes, since they met two major conditions under which an index rebuild most likely will improve performance.

According to Burleson, an index rebuild can help under the following conditions.

http://www.dba-oracle.com/art_dbazine_idx_rebuild.htm

  • High index fragmentation:  The SQL workload has lots of table DML causing lots of deleted leaf blocks.
  • High index scan access plans:  The SQL workload is rich with index scans (index fast-full scans and index range scans)

The second condition definetely holds valid for my clients database. The application, RSA IGL is used for over 10 years without any archiving or regular house keeping and up to 100 Million entries in several important tables.

Last Updated: 15 November 2019
Hits: 4237
  • Database
  • Relational Database
  • Oracle
  • PL SQL
  • Index
  • Index Rebuild
  • performance-tuning

Create a new database

Go to Tools (Extras in German) and select the sub-menu SQL Anywhere 16 or 17.

Select menu item Create database ... (Datenbank erstellen ... in German).

Last Updated: 06 October 2019
Hits: 1737
  • SAP
  • SQL Anywhere
  • Database
  • Relational Database
  • SQL

Create an SQL Anywhere Database Service

In Sybase Database Central select the SQL Anywhere 16 or 17 context and then click on Services.

Right click into the pane below and select New > Service ... from the context menu.

Last Updated: 06 October 2019
Hits: 2498
  • SAP
  • SQL Anywhere
  • Database
  • Relational Database
  • SQL

Migrating old SQL Anywhere database

Recently my dad retired from running his own business as master wood worker. He ran an old business software specializing in supporting invoiving, creation of offers, address database and so on for small businesses.

This software happened to be based on an older version of SAP SQL Anywhere. 

Now my dad asked me to help him in backing up the address data as well as his old invoices, since he is required by law to keep them for up to 10 years.

Last Updated: 08 October 2019
Hits: 3259
  • SAP
  • SQL Anywhere
  • Database
  • Relational Database
  • SQL
  • Data Migration
  • Java
  • You are here:  
  • Home

  • Privacy Policy
  • Imprint

Back to Top

© 2023 Bolte IT Consulting