Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Multi-Environment Deployments Using Team Edition for Database Professi


Multi-Environment Deployments Using Team Edition for Database Professi

Author
Message
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17609 Visits: 32267
Comments posted to this topic are about the item Multi-Environment Deployments Using Team Edition for Database Professi

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Jamie Thomson
Jamie Thomson
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 Visits: 188
Good article Grant, I have one question though.

You say "you have to browse to the .user file and add it to your project and check it into source control"

I was speaking to Jamie Laflen from the DB Pro dev team once and he had kittens at the very suggestion of checking in the .user file. Do we have the option to put all the configurations into the .dbproj file and, if so, what is best practice here?

Great article!

-Jamie

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Matt Miller (#4)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7643 Visits: 18084
I was a bit curious about that too, but I'm seeing what Grant mentioned: when you add the separate configurations, some amount of that info seems to be put directly into the .dbproj file, and some more seems to go into the .dbproj.user file.

Some of it seemed to be duplicative, but I can't say I saw everything that was in the .user, duplicated in the .dbproj. I don't know what the best practice is as the moment (I just really started dabbling with this version), but it does seem to be the DEFAULT setting. The UI seems to put those there, and I don't see any way to change where that info might get stored.

For example - I can't find hide nor hair of the designated deployment DB connection string anywhere else, and I'd have to agree with Grant that that in itself would be something you'd want to set and keep with the project.

Perhaps ask Jamie what the best course of action for those things might be...

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17609 Visits: 32267
I can't take credit for it. One of the guys in my shop, Scott Abrants, is one of those obsesive compulsive types who has to find the deep dark secret behind everything. We found that when we were opening each other's projects, the database connection settings kept going away. At first there was recriminations & finger-pointing, but when it happened to Scott, he went and found where the connection was being stored. It's in the .user file. He did a bit more experimentation and sure enough, we can check that file into TFS, and then get it to each local machine and the connection strings for each configuration travel with it.

I'd sure be open to any other methods that work better and don't involve mucking about with files that normally remain hidden, but it's what we have.

I'm glad you guys liked the article. We're currently working through the best way to get incremental deployments working and automated, so I may have another one in six or eight weeks.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Scott Abrants
Scott Abrants
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 405
One catch you also need to add this file to the project - as Grant stated in his article - and not shown in the replies.

If anyone else has a better suggestion I would LOVE to hear it. The alternative works fine if no one else on your team ever has to open your project. Without that file and the contents you would have to recreate all of the settings again for a project that is checked into a central source control.
Scott Abrants
Scott Abrants
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 405
Oh yes and nice article! Keep up the good work and thank you for the plug.
Jamie Thomson
Jamie Thomson
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 Visits: 188
I wish there was a definitive answer here to the question "user file or dbproj file?". I use DBPro A LOT but I don't use configurations...after reading this article I'm think that I should.

I see the following in my .dbproj file:

PropertyGroup Condition=" '$(Configuration)' == 'Default' "

(I would put the full XML in here but as soon as I add some angle brackets it doesn't show up in the preview window for some reason)

so I kinda assume that it should be possible to define the other configurations in there. I don't know though.


I generally find that in this version hacking the XML seems unavoidable at times (for instance, there's no way to define the target database name except in the .user files)

Thanks again.

-Jamie

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Scott Abrants
Scott Abrants
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 405
Our solution gets us around having to hack the XML definition file; which is a good thing because not everyone here could handle that , nor should they.
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17609 Visits: 32267
Holy cow. We've been lucky so far then. We've been naming the project after the database. What a mess.

With the initial release, I did find that we were hacking the XML, but after the first service pack, we haven't had to do that.

Visual Studio provides a mechanism for creating more configurations with the Configuration Manager. Just don't get caught by the fact that there is a Solution Configuration and a Project Configuration. Until we had that seperation clear in our heads we ran into all kinds of problems.

I haven't seen the 2008 version yet, but if it fixes the .user issue, I'd love to know. That'd give me a fantastic excuse to upgrade. I'm sure they'll address this soon. I'm pretty sure they're aware of it. If I recall correctly, and hopefully no one will beat me if I don't, I asked Gert Drapers about the .user file and he acknowledged that they shouldn't have stored the connection strings there and would probably be fixing it in the future. That was at PASS last year.

We're using this tool more and more because it really is fantastic. But, because we use it more and more, all the little gotcha's get magnified.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Jamie Thomson
Jamie Thomson
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 Visits: 188
Grant Fritchey (1/24/2008)


We're using this tool more and more because it really is fantastic. But, because we use it more and more, all the little gotcha's get magnified.


Amen to that. It saves me buckets of time now that I know how to use it, but it took me a long time to get to that point.

-Jamie

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search