StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Can DDT import existing database structure?

Can DDT import existing database structure?

Ben Hayat — Wed, 11 Jul 2007 14:49:33 GMT

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!

RE: Can DDT import existing database structure?

Keith Chisarik — Wed, 11 Jul 2007 14:49:33 GMT

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!!!

RE: Can DDT import existing database structure?

Charles R Hankey — Sun, 08 Jul 2007 14:47:03 GMT

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 :)

RE: Can DDT import existing database structure?

Chan — Sun, 08 Jul 2007 03:59:00 GMT

Hi
Thank you for clarification.

May I know does DDT support IDENTITY_INSERT OFF while deploy data?

RE: Can DDT import existing database structure?

Trent L. Taylor — Sat, 07 Jul 2007 14:36:24 GMT

[quote]Any ideas when would include these? [/quote]

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.

RE: Can DDT import existing database structure?

Chan — Sat, 07 Jul 2007 13:01:29 GMT

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?

RE: Can DDT import existing database structure?

Ben Hayat — Mon, 02 Jul 2007 17:08:49 GMT

[quote]Or should we evaluate it a bit further?[/quote]

Let's give it a bit more time...:w00t:

RE: Can DDT import existing database structure?

Ivan George Borges — Mon, 02 Jul 2007 16:59:39 GMT

Gotcha!

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

RE: Can DDT import existing database structure?

Ben Hayat — Mon, 02 Jul 2007 16:27:06 GMT

[quote][b]Ivan George Borges (07/02/2007)[/b][hr]Oi Rogério.

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

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

Abraços.[/quote]

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)!

RE: Can DDT import existing database structure?

Ivan George Borges — Mon, 02 Jul 2007 09:58:24 GMT

Hi Charles.

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

RE: Can DDT import existing database structure?

Trent L. Taylor — Mon, 02 Jul 2007 09:13:10 GMT

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.

RE: Can DDT import existing database structure?

Charles R Hankey — Mon, 02 Jul 2007 09:03:02 GMT

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: )

RE: Can DDT import existing database structure?

Trent L. Taylor — Mon, 02 Jul 2007 08:50:17 GMT

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.

RE: Can DDT import existing database structure?

Ivan George Borges — Mon, 02 Jul 2007 07:02:47 GMT

Hey Ben.

Glad you got it now. ;)

RE: Can DDT import existing database structure?

Ivan George Borges — Mon, 02 Jul 2007 06:56:49 GMT

Oi Rogério.

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

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

Abraços.

RE: Can DDT import existing database structure?

Ben Hayat — Sun, 01 Jul 2007 17:46:46 GMT

Ivan you're "D" man! :) Excellent!

I don't know how the heck I missed that? Thank you very much!

RE: Can DDT import existing database structure?

Rogerio Mauri — Sun, 01 Jul 2007 14:51:25 GMT

Olá Ivan !!!

With which version of the SF you are working?

I do not see these options in the DTS? :(

Abraços...

Rogério

RE: Can DDT import existing database structure?

Ivan George Borges — Sun, 01 Jul 2007 13:03:46 GMT

Hi Ben.