April 27, 2011 at 1:12 am
Does freebcp support named fifo's? Is it possible to load data into SQL Server via a fifo?
April 27, 2011 at 1:24 pm
FreeBCP? Are you on Linux or Unix?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 27, 2011 at 3:47 pm
opc.three (4/27/2011)
FreeBCP? Are you on Linux or Unix?
And if so, how did you manage to install SQL Server???
April 27, 2011 at 4:20 pm
FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is running on *x. I think SQL Server on Linux is actually called MySQL 😛
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 27, 2011 at 4:36 pm
opc.three (4/27/2011)
FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is running on *x. I think SQL Server on Linux is actually called MySQL 😛
Ouch.
I'm not sure if I would claim MySQL playing in the same league as SQL Server does (especially not since the change of ownership)... But that's a different story all by itself.
Having a driver for *x systems to communicate with SQL Server might indicate there seems to be a need for a SQL Server style database in that environment (performance, maintainability and the low number of "Wrong result" bugs being reported compared to some of the other RDBMS's)... Or is it all just because there is no forum comparable to SSC for any of the other systems? 😉
April 27, 2011 at 5:00 pm
LutzM (4/27/2011)
opc.three (4/27/2011)
FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is running on *x. I think SQL Server on Linux is actually called MySQL 😛Ouch.
I'm not sure if I would claim MySQL playing in the same league as SQL Server does (especially not since the change of ownership)... But that's a different story all by itself.
I would never...it cannot be overstated just how far MySQL is behind SQL Server in terms of performance, maintainability, data types, auxiliary tools and services, language and engine features...it's a long list. MySQL is ahead of SQL Server in "wrong results" however...especially where async replication is concerned! I would venture a guess that with the new regime they'll be catching up on licensing costs pretty soon too! I have admin'ed and developed for MySQL 5.x enough to strongly prefer SQL Server...I have concrete reasons too so I guess it's not all based on personal preference 🙂
Having a driver for *x systems to communicate with SQL Server might indicate there seems to be a need for a SQL Server style database in that environment (performance, maintainability and the low number of "Wrong result" bugs being reported compared to some of the other RDBMS's)... Or is it all just because there is no forum comparable to SSC for any of the other systems? 😉
Some of the former, but mostly the latter 😎
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 28, 2011 at 12:12 am
I am running freebcp from Linux machine and I have installed SQL Server on Windows. I am trying to use freebcp to import data into SQL Server. I just want to know if freebcp supports streaming through FIFO?
April 28, 2011 at 7:01 am
abygaikwad17 (4/28/2011)
I am running freebcp from Linux machine and I have installed SQL Server on Windows. I am trying to use freebcp to import data into SQL Server. I just want to know if freebcp supports streaming through FIFO?
From reading the man page for fifo it seems like FreeBCP should not know, therefore not care if you're using fifo...if fifo is properly abstracting the named pipe and presenting a proper file handle freebcp should not know the difference and should work just fine. That said...I used "if" and "should" a lot, and I am not sure because I have never tried using FreeBCP with fifo and do not have a Linux environment anymore to test it. DB-to-file-on-disk and file-on-disk-to-DB is all I have used FreeBCP for.
I recently designed a system that needed to get data onto Linux (CentOS) and calling FreeBCP from a Java batch application solved the problem well. FreeBCP is not an exact copy of SQL Server BCP however. It's actually a manually reverse-engineered hybrid stuck somewhere between Sybase BCP and SQL Server BCP and is not complete in terms of the feature set when compared to either. Maybe someone will find this question, maybe through a search engine, and post a complete answer, but I think a Linux / FreeBCP Forum might be a better option for you to get answers for this particular question since I would categorize it as Linux-specific. ...sorry for the diversion yesterday re: MySQL...definitely post again if you have another question about SQL Server.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 28, 2011 at 7:09 am
Thanks for your post.
Freebcp seeks into a file and named fifo does not allow that. Thats the answer which I got to know.
April 28, 2011 at 7:11 am
Good to know...thanks for posting back.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply