March 12, 2012 at 4:23 am
Hello
I need to move data from a a instance of sql server to another instance in same domain. The source data is thrown by a query joining many tables. I need to move that data into a table in another sql instance with out using DTS, SSIS,Linked Servers.
Thanks in advance.
March 12, 2012 at 6:38 am
mandirkumar (3/12/2012)
I need to move that data into a table in another sql instance with out using DTS, SSIS,Linked Servers.
WHY??? SSIS is just the tool designed for this kind of task. How much data do you need to transfer?
[font="Verdana"]Markus Bohse[/font]
March 12, 2012 at 6:53 am
Is this for homework or interview by any chance?
March 12, 2012 at 7:01 am
This is a requirement. I have to do with out using SSIS, 🙂
March 12, 2012 at 7:02 am
No this is a project requirement:-)
March 12, 2012 at 7:06 am
What is the reasoning behind not being able to use SSIS?
There are a couple of others like BCP and bulk insert what you could use, but I would challenge why you cant use SSIS
March 12, 2012 at 7:11 am
As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others are used mostly for flat files to SQl. If I get a query to use BCP or others for this , it will be useful.:-)
March 12, 2012 at 7:21 am
BCP will work, get it to output the query into a flat file then upload the flat file to second server.
SSIS is very flexable, what do they mean by not flexible?
March 12, 2012 at 7:56 am
anthony.green (3/12/2012)
...
SSIS is very flexable, what do they mean by not flexible?
I guess, they mean that they have no idea how to use it, or they do have pretty good idea of what a "pain in da a*s" it is... 😀
Yep, SSIS is very flexible!
Yep, making some type of changes in it is a pain...
:hehe:
I would ask why "not linked servers"? What about using openrowset?
March 12, 2012 at 8:03 am
the only gripe i have with SSIS is when you change the destination to a different column length or type as the meta data references the old type until you open and close the DFT, but thats a tiny gripe (might be sorted in 2012 not played with 2012 SSIS yet).
totally forgot about openrowset, that would work also, but as its a a way of creating a linked server on the fly, this might not fall into the solution for the OP
March 12, 2012 at 8:13 am
mandirkumar (3/12/2012)
As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others are used mostly for flat files to SQl. If I get a query to use BCP or others for this , it will be useful.:-)
Always amazes me when I read that someone has asked someone do something - and also stipulated how it should be done. Presumably, if the owner were that knowledgeable, he'd be doing it him/herself. My advice is to use the right tool for the job, and not pander to the requester's prejudices.
John
March 12, 2012 at 8:29 am
John Mitchell-245523 (3/12/2012)
mandirkumar (3/12/2012)
As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others are used mostly for flat files to SQl. If I get a query to use BCP or others for this , it will be useful.:-)Always amazes me when I read that someone has asked someone do something - and also stipulated how it should be done. Presumably, if the owner were that knowledgeable, he'd be doing it him/herself. My advice is to use the right tool for the job, and not pander to the requester's prejudices.
John
I'm with you on that! But, are you aware of "cultural differences"? In some places/countries following the manager orders, no matter how stupid they are, is the only way to survive 🙂
In some respect I do like to manage my off-shore subordinates: they never argue with me!
In other respects, I HATE IT! Because: THEY NEVER EVER EVER ARGUE, EVEN IF THEY DO KNOW I'M WRONG AND HAVE SOME VALID POINTS TO MAKE!
:hehe::hehe::hehe::hehe::hehe:
March 12, 2012 at 8:32 am
I have an advice for OP:
Do it the most suitable way you think it should be done. Call it somehow different, so your requester will not be able to recognise as something he didn't want.
For example, if you go with SSIS path, call it Microsoft ETL-Automation tool!
Who knows, it may play well 😀
March 12, 2012 at 9:00 am
I have a question.. Why do they get to decide technology as a requirement?
I used to deal with this sillyness in a previous job, until IT finally took the position that technology is OUR choice, the business gets to define what they need done but how we get from point A to point G is not open to a business requirement..
This is a case where I would push back and challenge the requirement. SSIS IS almost certainly the best tool for this job and a requirement to use something like linked servers shows a fundamental lack of understanding.
Short answer, no, we will use any tech that makes sense, this includes SSIS and we won't accept a requirement that says otherwise.
CEWII
March 12, 2012 at 9:33 am
Elliott Whitlow (3/12/2012)
I have a question.. Why do they get to decide technology as a requirement?I used to deal with this sillyness in a previous job, until IT finally took the position that technology is OUR choice, the business gets to define what they need done but how we get from point A to point G is not open to a business requirement..
This is a case where I would push back and challenge the requirement. SSIS IS almost certainly the best tool for this job and a requirement to use something like linked servers shows a fundamental lack of understanding.
Short answer, no, we will use any tech that makes sense, this includes SSIS and we won't accept a requirement that says otherwise.
CEWII
I don't thing that the requirement went from business...
I think it was "advised" by OP manager or team-lead...
Also, depends who you call "business". If the requester is paying for technology, it's quite valid in some case for him to request some technical implementation - at the end you cannot base your solution simply on the fact that one tool is better than another. What about if the manager who request this stuff posses inside info that Microsoft is about to sell-in to Apple, so all MS related technology will disappear, therefore, he want everything to be runable of iPad :hehe:
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply