Unable to import Sybase ASE native data file using bcp

Question

Hi,

I have a requirement to import native BCP file from Sybase ASE to SQL Server.
Can anyone please advise on this?

Thanks.

Answer 1

Didn't you ask a related question the other day, and didn't I tell you to use character format?

I don't know about what the native format from Sybase looks like these days, but you would need to have quite bit of luck if you could import them directly with the BCP from SQL Server.

If you insist on using native files, you will have to write your own program. That is, you will have to find out what the native format from Sybase looks like. If you need help with that, you need a Sybase forum.

Well, who knows, maybe someone has written that program, but I am not going to Google that for you. My recommendation is that you use character files.

Answer 2

Hi @SwapnilSalunke-4731

I have a requirement to import native BCP file from Sybase ASE to SQL Server.Can anyone please advise on this?

Check this whether is helpful: https://www.red-gate.com/simple-talk/sql/database-administration/working-with-the-bcp-command-line-utility/, http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc30191.1600/doc/html/san1367605061117.html
You can also reference @Erland Sommarskog ’s reply or try to search in google for more replies of similar issues.

BR,
Mia
If the reply is helped, please do “Accept Answer” .

Answer 3

Hi @SwapnilSalunke-4731,

Is the reply helpful?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia

Answer 4

Hi @SwapnilSalunke-4731,

Is the reply helpful?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia

Answer 5

Hi @SwapnilSalunke-4731,

Is the reply helpful?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia