# Write to UNIX ftp servers

**URL:** <https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 20, 2020, 10:24pm UTC](https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623 "2020-04-20T22:24:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![john.coniff](https://avatars.discourse-cdn.com/v4/letter/j/91b2a8/32.png) [@john.coniff](https://forums.toadworld.com/u/john.coniff)\
**Post date:** [April 20, 2020, 10:24pm UTC](https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623/1 "2020-04-20T22:24:03Z")

</div>

Hi. I need to be able to extract millions of rows from my database on a daily basis to a UNIX ftp server. Will Toad be able to do this?

---

<div class="post-metadata">

**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\
**Post date:** [April 21, 2020, 7:23am UTC](https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623/2 "2020-04-21T07:23:02Z")

</div>

Have you already installed a trial version of any Toad? What database do you use and what exactly do you mean by "extract"?

---

<div class="post-metadata">

**Author:** ![john.coniff](https://avatars.discourse-cdn.com/v4/letter/j/91b2a8/32.png) [@john.coniff](https://forums.toadworld.com/u/john.coniff)\
**Post date:** [April 21, 2020, 2:28pm UTC](https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623/3 "2020-04-21T14:28:15Z")

</div>

Hi, thanks for your reply. Yes, I have a trial version installed. By extract, I mean "unload to big\_file.txt; select \* from big\_table" and I have an output of 30 millions rows. I'm basically unloading an entire database. I can do this in Toad (though I haven't tried with the entire table due to space concerns; in Brio this things takes like 3 hours to run) and write to my windows file system; I need to be sure I will be able to write to a UNIX server for our external stakeholders to ftp to their systems.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [April 21, 2020, 10:08pm UTC](https://forums.toadworld.com/t/write-to-unix-ftp-servers/49623/4 "2020-04-21T22:08:33Z")

</div>

There’s two ways to FTP a result set from Toad Datapoint, although 30 million rows might be straining the client, depending on how beefy your workstation is...🙂

Both of the following means requires you to save results on some drive reachable by TDP and FTP....e.g. a file created by TDP via export or Save-As, etc.

• Crack open the FTP Connections pane within TDP (Main menu View-\> FTP Connections) and define your FTP sites there. In this way, Toad has built-in FTP that allows you to upload your files… see snap below.  
• The Automation Designer in TDP has an FTP task. The nice thing about this is that you can schedule your FTP uploads and have them be hands-freely done on a regularly scheduled basis. See second snap below, where I have a simple two-step process that issues a SELECT query to bring back results from my Local Storage (or local drive) and then uploads to my desired FTP site.

 ![image](https://global.discourse-cdn.com/quest/original/2X/0/03fcdbb00b792f4f5834ffb2c33c206dd7165a40.png)

 ![image](https://global.discourse-cdn.com/quest/original/2X/f/fe6981ce8fa1136d646d1c8bbf5288843c8da5e9.png)
