We are planning to migrate from DB2 to MS SQL database. At present all our webMethods jdbc adapter services is created based on DB2 connection. Does the migration to MS SQL impacts these adapter services (select, insert, stored procedures).
Else, can we use these adapter services as it is and on updating jdbc adapter connection to look up on new MS SQL db will do ?
Make sure you have the same table and SP names as in your DB2. After migration I would still suggest you manually check the adapter service to see if it is pointing to the correct table names and test it rigorously.
Can someone please tell me how to migrate DB2 to MS SQL on which webMethods is sitting?
Currently we have wMs on DB2 and now we want to migrate DB2 to MS SQL.
Please suggest some rough idea’s like if wMs developer should do or DBA’s needs to be involved. Thank you very Much…
We only have migrated from DB2 to Oracle very long time ago (while migrating from wM 6 to wM 7) and for one of our parts from MS SQL to Oracle last year while migrating from wM 8.2 to wM 9.12.
Both migrations where accompanied by an OS migration, forcing to be a side-by-side migration, only migrations in 6.x or in 7.x where done by overinstallm which is no longer supported by recent releases.