“Add as object” or “Add as script”? [SSDT]

re: “Add as object” or “Add as script”? [SSDT]

Kyle Hale — Fri, 04 Jan 2013 16:28:04 GMT

When I right click and choose Add Script, the Add New Item dialog box gives me 4 options in SSDT:

Post-Deployment Script

Pre-Deployment Script

Script (Build)

Script (Not in Build)

And as you can imagine, choosing each one changes the Build Action property accordingly.

Do you not get that dialog when you choose Add->Script?

re: “Add as object” or “Add as script”? [SSDT]

jamiet — Fri, 04 Jan 2013 16:35:46 GMT

Kyle,

Good point, yes, you do get those 4 options. My point, not explained too well I guess, is that if you choose the default option (which I suspect many will do - because I've seen many colleagues do it) then it won't be in the build.

Thanks for allowing me to clarify.

-J

re: “Add as object” or “Add as script”? [SSDT]

AlexK — Fri, 04 Jan 2013 21:01:42 GMT

This is a typical example of GUI killing productivity. The task of coalescing text files into a single script and/or building a database is trivial - it is about 100 lines of C# code in two simple classes. It took me less than an hour to write, and it just works without issues for several years. It would probably take me more time to write a blog post like yours than to develop a working solution from scratch in C#. More to the point, if I want to change the way I work with sql scripts, I can do it right away...

re: “Add as object” or “Add as script”? [SSDT]

Bill Anton — Fri, 11 Jan 2013 22:22:08 GMT

interesting approach. I also prefer handcrafting the DDL for each object...and the table designer GUI is a pain in the arse. Instead of starting with a script object, I change the default editor from...

Microsoft SQL Server Data Tools, Editor Selector

to...

Microsoft SQL Server Data Tools, T-SQL Editor

To do this, just right click on a table file in the object explorer and select "Open With"...then click/select the "Microsoft SQL Server Data Tools, T-SQL Editor" and set as default. Screenshot: http://byobi.com/blog/wp-content/uploads/2013/01/Open-With....png