Book a Demo

Author Topic: Database import without deleting existing tables?  (Read 3687 times)

mpolo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Database import without deleting existing tables?
« on: August 09, 2005, 02:37:53 pm »
Does anyone know how this can be done. We use the imported tables alot in our design, and it is giving us fits to have to re-create the associations when we re-import a table.

Thanks!

Michael

thomaskilian

  • Guest
Re: Database import without deleting existing tabl
« Reply #1 on: August 10, 2005, 01:27:46 am »
I really can't figure out, what's the question...

mpolo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Database import without deleting existing tabl
« Reply #2 on: August 11, 2005, 05:10:16 am »
When you import tables over top of existing ones, the action taken is to delete the tables, then re-create them from the database schema.

In our current design, we these tables pulled into diagrams where we show interactions with the tables in question. On re-import, those tables and links need to be recreated, which is a pain.

I was looking for suggestions on how to import a database table in a way that does not delete and recreate the table itself, or a way to 'fill' an existing table with all the attributes and operations from the imported table.

Thanks,

Michael

thomaskilian

  • Guest
Re: Database import without deleting existing tabl
« Reply #3 on: August 11, 2005, 05:29:53 am »
That's clearer now. But I guess there is no good answer to your question. You might look at Paolo's answer regarding round trip engineering which describes the core problem - also with database RE.

mpolo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Database import without deleting existing tabl
« Reply #4 on: August 11, 2005, 05:46:48 am »
Until something better comes along our current woraround is to not associate directly to a table, but to a boundary element instead. We will still have to make sure that any reimported tables are put back into the boundary, but at least we will not lose our associations.