Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 sql script for downloading text data from server

Author  Topic 

Lovey Agrawal
Starting Member

1 Post

Posted - 2013-10-11 : 16:51:20
Hi,
I am new to sql scripting, i need to download text data from remote server database(postgres) to my local machine. How should i start, and how should i write sql script for this... plz help.. i have my thesis work pending.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-12 : 06:03:09
you can use multiple approaches

1. OPENROWSET
http://technet.microsoft.com/en-us/library/ms190312.aspx

2. Linked server setup
http://technet.microsoft.com/en-us/library/ff772782.aspx

3. Export Import Task
http://technet.microsoft.com/en-us/library/ms140052.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -