Database and App migration

Order Service

If you got a task of porting your application from one database to another one, you're at the right place! We at DB Best has built expertise of many years converting hundreds of applications and databases between Oracle, Sybase, DB2, MySQL, Informix, Access mainly to SQL Server. We do it fast, reliable, and low cost – and the most important thing is that the risk of your migration project is significantly reduced – relying on the team that designed migration tools, created migration whitepapers, trained customers and partners, and lives and breathes cross-platform database systems ensures successful delivery of your migration project.

Why migrating with DB Best?

  • Since starting at 2002 in the Bay Area, DB Best has been focusing on creating database/application migration tools and providing services. In 2005 Microsoft acquired DB Best Database Migration Suite, which became later SQL Server Migration Assistant (SSMA) family of migration tools. The core technology developed by DB Best allowed easily and reliably port one SQL dialect to another one (e.g. PL/SQL to Transact-SQL). During the next few years DB Best has been supporting SSMA and creating new versions of it (SSMA for Oracle, Sybase, Access, and PowerBuilder).

    While partnering with Microsoft and its customers DB Best has delivered hundreds of successful migration projects covering a variety of custom and packaged application migrations (e.g. Siebel, Peoplesoft, SAP, Axapta, etc.). With 80+ employees in 3 offices in US and Europe, DB Best provides rapid response and assistance to customers worldwide across industries.

    DB Best can deliver migration projects end-to-end starting with migration complexity assessment through live deployment, or focus on certain phases of migration projects (for example, database schema conversion, modifying application source code to become compatible with SQL Server, converting Perl and shell scripts to run on SQL Server, creating data migration packages, etc.).

  • As a partner in Microsoft Migration Center of Excellence, we get engaged in very interesting replatforming projects working with enterprise customers on making sure migrations are done right.

    There are also a lot of migration projects happening with ISVs. They usually can be divided into 3 types:

    1. Porting software products to support SQL Server.

    2. Packaged solutions for porting existing ISV customers to a new SQL Server version of their product. It usually includes creating a tool/script for moving data and possible business logic, and a technical migration guide.

    3. Delivering the service of migrating the existing ISV customers to the new SQL Server version. It many times involves performing software upgrades as well.

    4. Whether you're considering migration to cut costs or consolidate systems, or need to come up with a business case justifying migration – let us know. Send an email to info@dbbest.com, or give us a call at 408 202 4567 — you're in good hands.

 

Migration offerings

  • DB Best migration offerings include conversion of Oracle, Sybase ASE, Sybase ASA, DB2, DB2 UDB, MySQL, Informix, Access applications and databases to SQL Server 2005/2008.

    Typical engagements are listed below, and can be customized based on specific customer scenarios.

    Migration complexity assessment — usually 2-5 days onsite + 5 days remote. Includes:

    • Database migration assessment – analyzing the existing database schemas by using Migration Analyzer module of SSMA – tables, indexes, triggers, stored procedures, functions, packages, sequences, views. coming up with precise estimates of the manual efforts of completing porting these objects to SQL Server after running SSMA.

    • Application conversion assessment – analyzing existing applications source code (e.g. Java, VB, PowerBuilder, C, etc,) by using SSMA and manually. Coming up with estimates for modifying embedded SQL statements to become compatible with SQL Server, or porting the code to another platform (e.g. to .Net).

    • Data migration assessment – estimating efforts to prepare SSIS or SSMA packages, and coming up with strategy for full, incremental, or replication types of data migration.

    • Assessment of integrating with 3rd party applications – reviewing all existing interfaces and "entry points" to the database, and coming up with estimates for making changes in these interfaces.

    • Assessment of testing, tuning, and deployment efforts.

  • Creating ROI analysis/migration business case — 1-3 weeks onsite/remote. Includes:

    • Reviewing current licensing, maintenance, support, hardware/software, personnel costs.

    • Coming up with expected cost of running on SQL/Windows platform.

    • Coming up with expected cost of running on SQL/Windows platform.

    Delivering end-to-end migrations: Oracle-to-SQL Server 2008, Sybase-to-SQL Server, DB2-to-SQL Server, Informix-to-SQL Server, MySQL-to-SQL Server. Includes:

    • Database migration – converting schema and migrating data.

    • Application conversion – modifying applications to become SQL Server compatible, or rewriting applications on a different platform.

    • Testing, performance tuning, and benchmarking.

    • Deployment in production — after testing, validation and tuning is completed, deploying the new converted system in production environment.

 

About Company

DB Best Technologies started at 2002 in Santa Clara, CA as a technology startup. We developed a state of the art database migration technology, which was acquired by Microsoft SQL Server group in 2005 and became a foundation for Microsoft SSMA product line. Since then DBBest team expanded into areas of web2.0, mobile software and business applications. We provide custom services and develop products of our own.