StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » DDT Questions

««12

DDT QuestionsExpand / Collapse
Author
Message
Posted 01/26/2007 10:50:49 AM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:29:55 PM
Posts: 1,168, Visits: 2,931
So, one more question. If I don't define any views or sprocs in DDT, will it still delete all existing views/sprocs in the database?
Post #6304
Posted 01/26/2007 11:15:08 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:12:17 AM
Posts: 4,243, Visits: 4,288
They get deleted and recreated every time. 
Post #6309
Posted 01/26/2007 11:21:17 AM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:29:55 PM
Posts: 1,168, Visits: 2,931
Just be absolutely clear (as this is NOT something I want to make a mistake on), I have a profile with NO sprocs or views defined (I would have tables defined though) and I deploy this package to an existing database that has existing views/sprocs, after the deployment, I would have no views or sprocs in the database, right?
Post #6310
Posted 01/26/2007 12:54:42 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:12:17 AM
Posts: 4,243, Visits: 4,288
Correct.
Post #6313
Posted 01/26/2007 8:18:10 PM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:29:55 PM
Posts: 1,168, Visits: 2,931
OK, so if I just wanted to use the DDT to deploy data (never schema) how would I do that?
Post #6325
Posted 01/27/2007 10:28:53 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:12:17 AM
Posts: 4,243, Visits: 4,288
Look at the Database Installer Sample that is in the Samples and Solutions section of the forum.  This sample shows you how to use the DatabaseMigrator class.  The meta-data and data deployment are two different methods.
Post #6336
Posted 01/28/2007 7:15:08 PM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:29:55 PM
Posts: 1,168, Visits: 2,931
Glad to here it. I'll look at the sample again (this time I'll try to absorb more of it). I don't think the DDT will work at all for my normal db updates, but I'm using for my security db (separate db, no fancy-smancy SQL stuff to work about) and it works great and I'm hoping I can use it to update some static application data. That will be nice

Thanks for all the info!
Post #6359
« Prev Topic | Next Topic »

««12

Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 9:12am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 11 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.