Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Multi-Environment Deployments Using Team Edition for Database Professi Expand / Collapse
Author
Message
Posted Monday, August 17, 2009 7:59 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 15,662, Visits: 28,055
SCOTT!

That's a really hard problem, as I'm sure you're aware. I don't have a good answer. You should start a new thread. You might also consider posting that question to Social.msdn.microsoft, the DBPro forum.

I am aware of another team that's trying to solve the problem of managing databases through ERStudio. They're having a very hard time of it too. I just think it's a poor choice of tool for managing deployments. Embarcadero tools, damned fine tools, are built to support multiple environments, but they don't support any single environment, such as SQL Server, terribly well.


----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #772394
Posted Tuesday, August 18, 2009 6:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
Hey there Grant! Thank you for the reply and pointing to the DBPro forum - I will give that as shot as well.
This is a show stopper, to some degree. There is a preconcieved notion that the modeling tool should drive all schema changes. Aside from the fact of domains and a nice picture it is really compounding the problems with deployments. Not to say the modeling tools are to blame for deployment issues, but this is standing in the way of resolving some common build and deployment problems. And the worse part is there are better ways and one of them is implementing Declarative Database Development using Team Edition for Database Professionals.
Post #772624
Posted Tuesday, August 18, 2009 12:15 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 15,662, Visits: 28,055
While I realize that good carpenters don't blame their tools & all that... but when a carpenter is being told he has to drive nails with a coping saw... can he complain about it then? I'd say yes.

This is the same situation. Yes, the tool can sort of do what you need, but not terribly well, and it's not it's primary purpose, and the gap between it's purpose and the use you're putting it to is pretty large.

Good luck with the coping saw.


----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #772950
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse