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.
Author |
Topic |
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-09-28 : 15:45:02
|
Hi,We have to transfer Data from Sybase to SQL Server database and are planning to use bcp. Is the queryout functionality also available in Sybase since we just need to select some rows of a table or is there any other option that can be used on Sybase that is equivalent to queryout of SQL Server?Thanks--Harvinder |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-28 : 16:25:50
|
To see what options bcp has in Sybase, run bcp /? at the command line. If you have both Sybase and SQL client tools installed, then make sure you navigate to the bcp.exe for Sybase, otherwise you might get the SQL options. They may behave the same though.Tara |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-09-28 : 16:29:16
|
I checked that but not able to find anything similar to queryout so drop this message(just to make sure i am not missing any other similar option) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-09-28 : 20:33:10
|
You can run sybase bcp and let it generate the format files for you, then edit the format files to say SQLCHAR instead of SYBCHAR and use SQL's BCP to load the files.--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers. |
|
|
Pritesh_Zaveri
Starting Member
1 Post |
Posted - 2013-01-14 : 07:03:46
|
@Kselvia Can SQL Server's bcp be used to fetch data from Sybase? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|