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


Decouple the Tools


Decouple the Tools

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619302 Visits: 21251
Comments posted to this topic are about the item Decouple the Tools

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
t.franz
t.franz
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3047 Visits: 465
I'd guess that there are a lot of small and big shops out there, which uses bcp and sqlcmd regulary (e.g. bcp for simple import / export tasks where SSIS is just to big and clumsy and sqlcmd.exe for the default jobs created by Ola's maintenance solution) as server tools. Having them to be installed separate would slightly increase the security (when they are NOT installed) but could cause trouble too (when forgotten to install) and decrease security (when you miss a critical security hotfix for them, while you always install the latest CUs for the SQL Server main installation).

Of course it would be nice to have "regular" import/export routines, which does not need to use external tools or legacy stuff as the Ole Automations.
Dave Poole
Dave Poole
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: General Forum Members
Points: 62670 Visits: 4023
I think bcp could do with enhancements. As a high speed import/export tool it has served me well. The ability to handle parquet/Orc files would be fantastic. Far more cross platform data exchange takes place these days as the love affair with data lakes continues

LinkedIn Profile
www.simple-talk.com
Cary Hower-563110
Cary Hower-563110
Mr or Mrs. 500
Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)

Group: General Forum Members
Points: 519 Visits: 235
From a strictly product point of view I can understand and even agree with the decoupling. However, for those of us who have to maintain SQL Server instances that cannot connect to the Internet, this is becoming a major pain. I would like Microsoft to be more aware of those of us that don't have access to the Internet and consider an alternate delivery mechanism.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619302 Visits: 21251
Cary Hower-563110 - Monday, March 5, 2018 5:34 AM
From a strictly product point of view I can understand and even agree with the decoupling. However, for those of us who have to maintain SQL Server instances that cannot connect to the Internet, this is becoming a major pain. I would like Microsoft to be more aware of those of us that don't have access to the Internet and consider an alternate delivery mechanism.


They should have offline, easier to install mechanisms, I agree.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Doug Dodge
Doug Dodge
SSC-Addicted
SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)

Group: General Forum Members
Points: 473 Visits: 450
Steve Jones - SSC Editor - Monday, March 5, 2018 6:45 AM
Cary Hower-563110 - Monday, March 5, 2018 5:34 AM
From a strictly product point of view I can understand and even agree with the decoupling. However, for those of us who have to maintain SQL Server instances that cannot connect to the Internet, this is becoming a major pain. I would like Microsoft to be more aware of those of us that don't have access to the Internet and consider an alternate delivery mechanism.


They should have offline, easier to install mechanisms, I agree.

Curious about what sort of approach folks are thinking of here. Cory mentioned being 'offline' and my suspicion, being the too-literal thinker I tend to be Smile, is that this would not mean DVDs but rather a controlled download from a secure location. I was thinking that some sort of 'widget' could monitor versions and provide suggestions or something similar.

In other words, what practical approaches would work?

Rod
Rod
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29281 Visits: 2775
FWIW, I haven't been able to run Books Online in quite a while. Guess I'm one of those whose still having problems getting that to work.

Kindest Regards,Rod
Connect with me on LinkedIn.
sknox
sknox
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11252 Visits: 3425
David.Poole - Monday, March 5, 2018 1:31 AM
I think bcp could do with enhancements. As a high speed import/export tool it has served me well. The ability to handle parquet/Orc files would be fantastic. Far more cross platform data exchange takes place these days as the love affair with data lakes continues

The major reason bcp is high-speed is because it is focused on a specific pipeline between a specific set of potential input/output formats.
SSIS is what you want for more formats or a customized pipeline. In my experience, a well-designed SSIS package can be as efficient as bcp in terms of raw performance, while providing more complete error and performance logging.
Having said that, what I'd really like is a BCP native-format file source/destination for SSIS.

Chris Harshman
Chris Harshman
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: 37941 Visits: 7164
Sometimes they've decoupled too much. For example, I recently had to rename an Analysis Services instance for SQL Server 2016. It's actually a fairly easy thing to do, but unfortunately the tool to do that is bundled with Management Studio, which wasn't installed on the server, so I had to install that client side program first to get the server side tool Hehe
https://docs.microsoft.com/en-us/sql/analysis-services/instances/rename-an-analysis-services-instance
Steve Jones
Steve Jones
SSC Guru
SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619302 Visits: 21251
Chris Harshman - Monday, March 5, 2018 10:51 AM
Sometimes they've decoupled too much. For example, I recently had to rename an Analysis Services instance for SQL Server 2016. It's actually a fairly easy thing to do, but unfortunately the tool to do that is bundled with Management Studio, which wasn't installed on the server, so I had to install that client side program first to get the server side tool Hehe
https://docs.microsoft.com/en-us/sql/analysis-services/instances/rename-an-analysis-services-instance


Why install the client tool on the server? Can no clients connect to the server? Or does this change only local instances? Either way, decoupling still makes sense. Install the client tool if you need it. I'd prefer the client tools be separate as well, so that if you need the SSAS tool, you don't need everything else.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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