SAP Best Practices for Data Migration :repositories only on MS SQL Server ?

[hans_segers]

Hi,

I'm implementing the "SAP Best Practices for Data Migration" (see https://websmp109.sap-ag.de/bp-datamigration).

As part of the installation you have to install MS SQL Server Express Edition. The installation guide contains detailed steps to do this. All repositories for Data Services should be running on SQL Server, according to the installation guide.

The customer I'm working for now does not want to use SQL Server, but DB2, as company standard.

So I use DB2 for the local and profiler repositories.

I notice however that the web application http://localhost:8080/MigrationServices does not support DB2.The only database type you can select in the configuration area is MS SQL Server.

Is this a limitation, a by design ?

[Former Member]

Hans,

The current release of SAP Best Practices for Data Migration, v1.32, supports only MS SQL Server. The intent when developing the DM content was to quickly set up a temporary, standardized data migration environment, using tools that are available to everyone. SQL Server Express was chosen to host the repositories, because it is easy to set up and can be downloaded for free. Sone users have successfully deployed the content on Oracle XE, but as you have found, the MigrationServices web application works only with SQL Server.

The next release, including the web app, will support SQL Server and Oracle, but not DB2.

Paul

[hans_segers]

Thanks for the reply.

I'll try to get it working on DB2 repositories.

Hans