StrataFrame Forum / StrataFrame Database Deployment Toolkit / Database Deployment Toolkit (How do I?) / Reimport data structure / Latest Posts

RE: Reimport data structure

Chan — Sat, 20 Jan 2007 11:43:06 GMT

Hi,
Today I come a case that, I modify few of my table structure using my diagramming tool and sync to actual database. When I try to import them back to DDT, they are created under another database. I deleted my original table from DDT and move the changed back to existing database (DDT). This break my BO mapper. I got to reconfigure them.

Therefore, I hope you can reconsider to implement merge feature in DDT.

Beside, I also tried to use DDT (which import from database previously) to create my database. And I found that, it miss out something. Some of my indexes and default constraints lost. When I use my diagramming tool to recompare with this newly created database, it shown alot of differences.

Thank you

RE: Reimport data structure

Ben Chase — Tue, 16 Jan 2007 10:18:02 GMT

Once you re-import the 3 new tables, you can then copy the tables from the Database_1 node to the correct database and delete the Database_1.

RE: Reimport data structure

Chan — Mon, 15 Jan 2007 20:24:04 GMT

Hi,

Sorry, I couldn't get you.

I am using xcase diagramming tool to design my database. It only contains 5 tables. I have generate script from this tool and run at SQL Server. Now, my sql server database contains these 5 tables. I import them to DDT and create my business object using BO mapper. After testing with these 5 BOs, I back to my diagramming tool and create 3 more tables, "sync" them to sql server database again. Now, my sql server database contains 8 tables. I want to import this newly added tables to DDT within existing profile.

What I found is that, DDT will import these 3 tables under different database node. So, I would get mydatabase and also mydatabase_1. Anyway I could ask DDT to import them into mydatabase instead of create new database called mydatabase_1?

Thank you

RE: Reimport data structure

Ben Chase — Mon, 15 Jan 2007 10:38:04 GMT

Yes, when you import, you can import a view tables at a time and they will just be added to the database within the profile.

Reimport data structure

Chan — Fri, 12 Jan 2007 23:51:00 GMT

Hi,
Any way to "merge" table strucuture to DDT by reimport database?
I am asking so because I am importing database by progressive, few tables in batch (by module). It is to easier my development.

Thank you