Wednesday, January 19, 2005
Development 1/19/05
Well, I'm finally working on creating a new way of handling the Database<->SourceControl mapping. I've decided to try and create a treeview mapping concept that will show database objects on one side, source control projects and items on the other and then show the mapping as lines, similar to the way DTS shows transformation items.
In addition, the user will be able to drag items to perform mapping between them, drag folders onto projects to perform "best fit" matching for an entire schema, see which items are missing mappings, etc.
The form will also have the ability to create objects in the database that exist in Source Control but not in the database as well as vice versa. Hopefully all mapping can be easily managed from this page.
Below is an image of the test form with a concept of my idea:
In addition, the user will be able to drag items to perform mapping between them, drag folders onto projects to perform "best fit" matching for an entire schema, see which items are missing mappings, etc.
The form will also have the ability to create objects in the database that exist in Source Control but not in the database as well as vice versa. Hopefully all mapping can be easily managed from this page.
Below is an image of the test form with a concept of my idea:
