Alternative process except by doing using linked server?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Alternative process except by doing using...

Alternative process except by doing using linked server?

Rate Topic

Display Mode

Topic Options

Author

Message

SQL Dev-938873

Posted Tuesday, October 09, 2012 11:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:03 AM
Points: 90, Visits: 417

Hi SQLites,

I want to update the data from one sql server to another sql server.

Is there any alternative process except by doing using linked server?

please let me know.

Thanks

GaNeSH

Post #1370684

chandan_jha18

Posted Wednesday, October 10, 2012 6:07 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 408, Visits: 1,666

Can you provide an example of a task based on what you need.

In general if the data is distributed, you will have to use linked server or replication depending upon what you need. Linked servers are not very great but not very bad too especially if you know how to use them. for example, I prefer to avoid linked server in joins and instead fetch those columns with proper filters to local temp tables and use that. I can go to some more length here but first tell us what exactly is the requirement.

Thanks
Chandan

Post #1370871

vyas

Posted Wednesday, October 10, 2012 6:12 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

You can transfer the data using ssis into stage table on target server and update.

if the delay is acceptable and it is an repeating task.

Post #1370876

tim_harkin

Posted Wednesday, October 10, 2012 6:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:07 PM
Points: 138, Visits: 355

OPENROWSET is an option.

http://msdn.microsoft.com/en-us/library/ms190312.aspx

Post #1370881

Lowell

Posted Wednesday, October 10, 2012 6:30 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:28 PM
Points: 11,627, Visits: 27,692

if you think about it at a little higher level, the question is :
how can [something] make two connections and transfer data.

just as you are seeing, the possibilities boil down to what you are familiar with: linked server, openrowset, SSIS, or the actual programming language of your choice.(ie vb.net/c#.net , for starters.)

if you are talking about moving data changes regularly, you might want to consider built in SQL technologies like replication or logshipping; you can also do something with ipropagating by using CDC and reading the changes from there.

If you are talking about dschema or data differences, tools like Redgates SQL Compare or Redgates SQL Data Compare might be an option.
if you offer a bit more detail on what you are trying to accomplish, we can offer better suggestions.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1370884

« Prev Topic | Next Topic »

Permissions