Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings

Repair database schema from App Architect

Status: Under Consideration
by Silver Contributor ngaller on ‎06-10-2010 07:06 AM

I thought I had sent this already but I guess I forgot to hit Post, so here goes - sorry I am cutting it a bit short because I don't feel like retyping it all...

 

I would like a "Repair" option in App Architect that would rebuild the database schema based on the project's metadata.  

 

Key advantages:

* avoid need to separately bundle schema changes when shipping a web customization

* ease distributed development scenario (in case each developer have their database)

* serve as an "integrity check" of the project's metadata (the problem is that if there is a field missing in the database you will not find out about it until visiting the page where SalesLogix tries to access that field)

 

Thoughts:

* How to handle indexes and joindata?  

* Can picklists be handled in the same way (at least creating empty picklists where needed) - this might require associating the field with a picklist when editing an entity

* This should be interactive so that the user has a chance to review the changes before applying 

Status: Under Consideration
Good idea. Will add it to the list and discuss design options. Any additional comments are encouraged.
Comments
by scottdurgan
on ‎06-16-2010 04:18 PM
Status changed to: Under Consideration
Good idea. Will add it to the list and discuss design options. Any additional comments are encouraged.

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels