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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sybase-->SQL Server

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
Go to Top of Page

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)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-28 : 16:30:11
Sybase forum at dbforums.com:

http://www.dbforums.com/f6

Tara
Go to Top of Page

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.

--Ken
I want to die in my sleep like my grandfather, not screaming in terror like his passengers.
Go to Top of Page

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?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-01-14 : 13:26:07
quote:
Originally posted by Pritesh_Zaveri

@Kselvia Can SQL Server's bcp be used to fetch data from Sybase?



No.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -