Change Application's DBMS From DB2 > MS-SQL #mssql


Mike Moore
 

We plan to move our XPA application's data from legacy DB2 to MS SQL server.

I am considering one of the turn-key services (i. e. GoUp), developing an internal procedure, hiring SQL consultant.

It seems that there are three activities:

  1. Create the MS SQL database & schema
  2. Change the XPA project's data source entries from DB2 to MS-SQL
  3. Migrate the data from DB2 to MS-SQL


Does anybody have any experience or suggestions in evaluating the best way to complete this?


Thank you.


Charles Coe
 

Mike,
I would start here:
Migrating DB2 Databases to SQL Server (DB2ToSQL) - SQL Server | Microsoft Learn

Run the SQL Server Migration Assistant to completion and then change your Magic DB source entries from DB2 to SQL Server.

Also check out this resource: Migrate Databases From IBM Db2 to SQL Server in 8 Easy Steps - Learn | Hevo (hevodata.com)
Charles

PS - the BB2023 treats were enjoyed, thank you :)

--
Charles Coe, CPA, MCSE

New Orleans, Louisiana


sales professionalcomputingltd.com
 

Hi

I used the services of GOUP to migrate my pervasive magic9.4 to XPA and migrate to MSQL

They did a great job at a reasonable price.

Regards
Michael Charles 


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Charles Coe via groups.io <coe@...>
Sent: Wednesday, March 29, 2023 4:42 PM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: Re: [magicu-l] Change Application's DBMS From DB2 > MS-SQL #mssql
 
Mike,
I would start here:
Migrating DB2 Databases to SQL Server (DB2ToSQL) - SQL Server | Microsoft Learn

Run the SQL Server Migration Assistant to completion and then change your Magic DB source entries from DB2 to SQL Server.

Also check out this resource: Migrate Databases From IBM Db2 to SQL Server in 8 Easy Steps - Learn | Hevo (hevodata.com)
Charles

PS - the BB2023 treats were enjoyed, thank you :)

--
Charles Coe, CPA, MCSE

New Orleans, Louisiana


Mike Moore
 

Charles and Michael, thanks for your helpful replies!