SqlDbx
You are not logged in.
It will be very handy if "bcp out/in" feature for Sybase and MsSql is added to import export options.
Offline
There's a couple ways to do it.
One way is to use BCP api and second
is to execute bcp in background.
Which one you have in mind?
Offline
At least I shoul define required BCP options from a GUI then BCP can be executed at background. It should return me the message if the operation succeded or failed.
Thanks for your efforts..
Offline
I think it is a useful feature to have bcp. The only thing we have to think
how to implement it for different database in consisteng way
Offline
I agree, it will be very usefull. Basic Bcp parameteres for sybase and mssql are in common. I think it will be much more easier to implement sybase BCP than mssql's bcp.
For sybase, bcp.exe is located under %sybase%/%sybase_OCS%/bin. When connected to a sybase database through sqldbx, it can use this bcp.exe
There is no envoirenment variable defined for mssql side. To locate the exact location of bcp, maybe the best way is to let the user to locate the location of bcp.exe for microsoft.
Offline
Thanks for your input. Let's see what we can do
in this area.
Offline
You added bulk copy support for Sybase and MSSQL but it comes disabled. How can I use it?
Offline
We did not make final decision yet, but
probably bcp functionality will not be
available in SqlDbx Personal
Offline