We are in the process of testing a migration of data from DB2400 to SQL Server 2008 database server. We are utilizing a tool called DBMoto to do the replication. We also use the software JD Edwards Enterpriseone. and in that software it comes with included batch programs that you can run that will perform a copy of data from DB2 to SQL.
But we have encountered an issue. The batch program we run in JD Edwards (R98403) to replicate the table structures from DB2 to SQL Server is unable to replicate a table’s primary key in SQL Server. This is due to the differences between the databases were DB2 allows columns will null values to be a part of the primary key whilst SQL Server does not allow columns with null values to be a part of the primary key.
Without primary keys on the tables in SQL Server, DBMoto tool cannot replicate the data.
Does anyone have any suggestions on how to programmatically copy table structures from DB2 to SQL Server were the primary key is properly translated, please let me know.