Import table structure?

[BrianVanderwiel]

Am I correct in assuming there is no way to import a table structure (non-delivered) into a custom repository in MDM? In other words, you must manually create each table?

...the gui is a bit tedious, are there any quicker/better ways to create custom tables?

[Former Member · Accepted solution]

Hi,

I guess the answer to your question is Yes.

Heres the justification..

Firstly, a database table shouldn't be confused with the tables we see in the repository. MDM stores the tables in the repository in the database in a different manner.

So, there is no one to one relationship.

Also, MDM also stores other details like unique, display fields, keywords, multilingual options etc. So, even if you import a table you would have to enter these details manually.

Also buddy, this is one time job and also a very critical job as it decides the efficieny of your MDM solution.

I believe that using the API's, you can expedite the process..Not very sure abt this though..

Hope that helps.

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[BrianVanderwiel · Accepted solution]

Tanveer,

10 points to you

I agree that the process in critical, I was just looking for a head start (like field names/length/type....).

Thanks for the reply.

Brian

[Former Member]

Hi,

Are you trying to import from one MDM repository to the other MDM repository?

Regards,

Rajani Kumar