Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

I want to migrate database SQL Server to DB2

Questions
Tags
Users
Badges
Fabiano Lima
(19●4) Jul 10 '23, 11:22 p.m.

I want to migrate ELM 7 database from SQL Server to DB2 and I would like to know if the logical structure and data model change as well. That is, if they are different structures. Can I migrate using data export/import?

0 votes

2 answers
1,096 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) Jul 11 '23, 1:18 a.m.

 Open the documentation (Library>Engineering Lifecycle Management documentation. Select your version. In the search bar type "database migration". 


There is a built in mechanism to export the database and to import the exported data. You do not have to know how the database is structured.

Fabiano Lima selected this answer as the correct answer

0 votes

Comments
Fabiano Lima
Jul 12 '23, 10:05 a.m.

There are some queries that make direct access to live tables to extract data (I know it's not recommended). If I change databases, do SQL Server queries change with respect to DB2 queries? Does the table structure (table and field names) change?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 12 '23, 10:15 a.m.

I do not know. My expectation would be, the tables are similar for different databases. But there are some differences such a keys etc.  The database schema/table details are not published, so I do not know.   So it might be possible that you need to test your reports.

One other answer

Permanent link
Daniel Moul
FORUM MODERATOR / JAZZ DEVELOPER (5.0k●13●18) Jul 11 '23, 7:25 a.m.

And if your databases are large and the time required to run repotools_[app] export and import is too long, you can ask via IBM Support whether or when a faster migration utility is or will be available.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,513
× 1,343

Question asked: Jul 10 '23, 11:22 p.m.

Question was seen: 1,096 times

Last updated: Jul 12 '23, 10:15 a.m.

Related questions
Confirmation Cancel Confirm