This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Newbie here... I was curious if there's a way we can invoke the database round tripping code present in the designer from the command line or otherwise from code. I'm investigating the possibility of using this in a simple "keep dev environments in sync" capacity. It would be nice if part of the local post build script was to sync the developer's database.
|
|
|
|
|
We don't currently offer this feature. We feel that schema round-tripping is useful for rapid prototyping, but its limitations mean it's not ideal as an automated way to update databases -- it can do a lot of the heavy lifting of creating tables, columns, foreign keys, etc., but often the developer will need to tweak the results by hand (e.g. text column sizes). Our plans for LightSpeed 3 include a much more robust and reusable capability for updating databases, which would be usable both as a post-build step and to update production databases. In the meantime, you might be able to get the effect you want using a Visual Studio macro. At the moment we always display the "select which updates to apply" dialog but we could create an "update with no confirm" command for you -- this would not be shown in the UI but could be called from a macro. I am not sure whether you can hook macros to build events but given all the automation capability in Visual Studio I'm sure there'll be some way (you might have to write a simple add-in). |
|
|
|
|
Makes sense. It can wait until your 3.0.
|
|
|
|
