Welcome Guest! To enable all features please Login or Register.



How to update a database from the model
#1 Posted : Wednesday, August 1, 2012 4:41:03 PM(UTC)

If you made changes to your Xomega object model and need to apply these changes to the database, then the following steps will help you to accomplish this.
  1. Open the Properties tab of the Database Change Script generator in the Database Layer folder.
  2. Set the database connection for the generator or use the project's default if set. Make sure that Excluded Tables are properly specified there. Otherwise the generator will assume they have been deleted and will create the statements accordingly.
  3. Set the Output Path for the location of the generated SQL script file.
  4. Run the generator and carefully review the generated script file to make sure it doesn't cause any negative side effects.
  5. If the script is fine, then run it against the database specified in the connection. The generated script is designed to be re-runnable, so that it would not fail or break something if you run it multiple times.
  6. To validate that you performed all the steps correctly, you can re-run the generator against the same database. This time around it should generate an empty script if the changes have been applied properly.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.