1

Context

I have been trying to design a page for an application that performs data migration tasks.

Problem statement

I have a page where all source DB tables and corresponding columns get matched with the target DB table and columns.

The issue I am facing is that it's possible to do mapping for 5 tables and each table having 30-40 rows. As of now, I have planned to show all table names in the sidebar example like list component and utilize the right side of space for table mapping.

Please check the link for a better understanding of the concept. Link:https://drive.google.com/file/d/1KHK58vD1ALe3zazyE0ff2ankE_68rNuc/view?usp=sharing

Is there any better way to do it? Thank you for help.

Edit: I tried to create a wireframe diagram. Please check: https://app.moqups.com/6yqahTxE5k/view/page/ad64222d5

  • Need some more screens to understand the context better? would be nice if the wireframes details how the current mapping has been planned – Swapna Apr 19 at 10:49
  • @Swapna updated please check. – Manish Apr 19 at 11:09
  • Thanks for adding the information; it's better though to add images directly in the post itself, in case the links break. – Glorfindel Apr 19 at 12:50
1

I had to edit the answer after our discussion, so please see one possible solution for the 'fixed' target tables.

This is just my suggestion, hope that more people could come with more ideas here. What I would have done is to create something similar like this below:

Fixed 5 targets

You would find the table names as names of tabs, so in one action you have the name and also the possibility to change pages. With the scroll down you can help the users with the high number of rows (columns) that the tables could have.

Also, the dropdown can be implemented as a Search&Select where users can search among all the columns in the database.

Good luck with your task,

| improve this answer | |
  • thanks for the suggestion. Design is good but I have a fixed number of target table which I need to accept, if I go for the above design they become optional. – Manish Apr 27 at 11:21
  • Oh, sorry. So you have 5 different target tables, right? But the source could be from anywhere in your database source, is it? – LinoBordin Apr 27 at 16:56
  • Yes, Correct. I have implemented a solution that is able to handle it. I will share that here soon. – Manish Apr 28 at 4:35
  • Ok, I have updated the answer. :) – LinoBordin Apr 28 at 9:37
  • I have implemented something like but table names on sides. But appreciate your efforts thank you. – Manish Apr 28 at 11:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.