SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Just a rant about how third parties design apps


Just a rant about how third parties design apps

Author
Message
Lowell
Lowell
SSC Guru
SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)

Group: General Forum Members
Points: 68765 Visits: 40905
jeff.mason (8/2/2012)
opc.three (8/2/2012)
jeff.mason (8/2/2012)
If someone wants to add a column to the middle of a table, they should get better SQL training.

This is exactly what Microsoft is up against. They have to provide for all things from all comers. Someone of your skill level is not their target audience when it comes to the Table Designer :-)


So what's their excuse for their own CRM product?


oof their excuse?

you've identified that your developers use the wrong tool for the job, need better training on how to do it better, but blame microsoft for the ramifications of using a "catch all possibilities" application for making your replication suffer?

I realize it's a rant, but i'd still think this is more of a training issue; there's usually multiple ways to do the same job in SQL Server, it's up to us to pick the most appropriate for the job onhand.

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
jeff.mason
jeff.mason
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2631 Visits: 2137
So why bother making replication able to replicate schema then? There is only one schema change that replication cannot handle -- dropping tables that are part of a publication. Why would Microsoft program CRM to drop tables to add a column? Why would you ever want to do that? Ignore exceptions (that in my opinion are bad form anyway) -- what possible reason is there for a professional product to drop a table whenever you want to add a column? That's the core of my rant.
jeff.mason
jeff.mason
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2631 Visits: 2137
And Lowell, I am blaming Microsoft for creating an application that uses SQL Server as its data repository that doesn't use their own best practices in maintaining its own database. Which given how SharePoint breaks all sorts of best practices is not an anomaly there.
Orlando Colamatteo
Orlando Colamatteo
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37762 Visits: 14411
jeff.mason (8/2/2012)
So why bother making replication able to replicate schema then? There is only one schema change that replication cannot handle -- dropping tables that are part of a publication. Why would Microsoft program CRM to drop tables to add a column? Why would you ever want to do that? Ignore exceptions (that in my opinion are bad form anyway) -- what possible reason is there for a professional product to drop a table whenever you want to add a column? That's the core of my rant.

I think the CRM problem is an extension of the problem you have with SSMS. MS was all but cornered into making the Table Designer be the way it is with respect to schema changes for the reasons mentioned earlier, and CRM seems to follow that same least common denominator approach. Do I like it? No. I get the starting point of your rant but for me, knowing why something I do not like is the way it is sometimes makes it easier to accept ;-) At least it is documented.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
jerry-621596
jerry-621596
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1259 Visits: 649
In my experience, SSMS does not script a drop and recreate of a table unless you insert the new column somewhere other than at the end. To append a new column doesn't recreate the table. I know this because I always have the save change script option active so I know what is going to happen before I commit the changes.
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