StrataFrame Forum

Can DDT import existing database structure?

http://forum.strataframe.net/Topic9866.aspx

By Ben Hayat - 7/1/2007

Is it possible for DDT to read an existing SQL2005 structure and import all fields, indexes and relationships? And then from that point on, we can use DDT to manage all the new changes?



If not, is it something that will be implemented?



Thanks!
By Ivan George Borges - 7/1/2007

Hi Ben.

By Rogerio Mauri - 7/1/2007

Olá Ivan !!!

With which version of the SF you are working?

I do not see these options in the DTS? Sad

Abraços...

Rogério

By Ben Hayat - 7/1/2007

Ivan you're "D" man! Smile Excellent!



I don't know how the heck I missed that? Thank you very much!
By Ivan George Borges - 7/2/2007

Oi Rogério.

This is part of the 1.6.1, soon in a theater near you. BigGrin

(we got a taste of it in the last class, held in Amarillo/Texas)

Abraços.

By Ivan George Borges - 7/2/2007

Hey Ben.

Glad you got it now. Wink

By Trent L. Taylor - 7/2/2007

Yes, this is a new feature that has been implemented in 1.6.1, which will be released soon.  I now imports relationships, views, indexes, and stored procedures and then you can maintain them from that point forward through the DDT.
By Charles R Hankey - 7/2/2007

Hi Ivan



Curious about how you got the uploaded screen shot to appear in the message rather than as an attachment.



How did you get the name of the attachment as it lives in the uploads/images folder on the server?



http://forum.strataframe.net/Uploads/Images/c5bd87ab-c12a-4eb6-96c7-af23.png



( auxillary queston - when I go to Edit Attachments and click on one of my previous uploads what am I breaking with the code that tries to run ? w00t )
By Trent L. Taylor - 7/2/2007

Instead of trying to use ifcode, just click the image link and it will take care of all of the details as to u0ploading the image, etc.

By Ivan George Borges - 7/2/2007

Hi Charles.

If your next question is "How did Trent make those torn edge effects?", that's SnagIt. Smooooth

By Ben Hayat - 7/2/2007

Ivan George Borges (07/02/2007)
Oi Rogério.



This is part of the 1.6.1, soon in a theater near you. BigGrin



(we got a taste of it in the last class, held in Amarillo/Texas)



Abraços.




Ivan, I knew I'm not crazy (yet) or blind, and now I see why I didn't see the option the first time. At first I was looking for this option on a machine that I had version 1.6 on it and when you showed me the screen shot, I then later on was looking at my Dev machine which has 1.6.1.



It was driving me crazy, because I had originaly looked at that menu, (but the wrong version)!
By Ivan George Borges - 7/2/2007

Gotcha!

Does that mean you are not going crazy, then? Or should we evaluate it a bit further? Tongue

By Ben Hayat - 7/2/2007

Or should we evaluate it a bit further?




Let's give it a bit more time...w00t
By Chan - 7/7/2007

Hi,

I just try out DDT 1.6.1, it does import more things than before. However, it still doesn't import trigger and user defined function.



Any ideas when would include these?
By Trent L. Taylor - 7/7/2007

Any ideas when would include these?

The DDT doesn't even support triggers and UDFs at this point so it would be pointless to import them at this point.  The DDT will have support for triggers in the near future, but UDFs will more than likely never be supported in this version of the DDT.  We may re-address it on the next major version, but there are a lot of complications that surround UDFs.  Triggers, however, will be supported in the near future.

By Chan - 7/7/2007

Hi

Thank you for clarification.



May I know does DDT support IDENTITY_INSERT OFF while deploy data?
By Charles R Hankey - 7/8/2007

I guess this is an IE thing.  Get a different dialog in Foxfire 2.0

where I get this one in IE

How about that Smile

By Keith Chisarik - 7/11/2007

I would just like to say that I also will appreciate the DDT supporting triggers in the future.



I never used them before today but I was faced with an ugly task in one of my apps that would have required either a Windows service or an ugly timer to monitor table activity so I looked into SQL triggers and it worked like a charm.



Getting the syntax was a chore but once I did, it automatically monitors my table for transactions and updates lookup tables any time my users sync their mobile databases.... nice!!!