Book a Demo

Author Topic: Sync Help  (Read 2075 times)

stefz

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Sync Help
« on: March 26, 2011, 07:33:38 am »
We're using the trial version of EA 8.0 to see if the software meet our requirements. We're searching for a software to maintain our software's dabatase model. We first tried to use the reverse engineering system to get the schema of our current DB (SQL SERVER 2008). The test consists of creating some new columns in a few tables in the generated database model and then  try to synchronize back with the DBMS. Is that possible? We're trying but did not find a way to do that. Does anyone can help us out?

Thanks in advance.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Sync Help
« Reply #1 on: March 28, 2011, 02:49:20 pm »
Stef,

I think the current version of EA (v8) only supports generation of "Create" SQL statements, no update statements.
So after you've changed something to the database layout you'll have to generate the ddl to create a new database schema.
I'm not entirely sure, but it could be that v9 (currently in beta) has some options to create update statements.

Geert