|
Home > Archive > ASE Database forum > April 2005 > BCP file compatibility between MS SQL Server & ASE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BCP file compatibility between MS SQL Server & ASE
|
|
| Tim Mottershead 2005-04-04, 8:05 pm |
| Hi,
We are working on a data migration project using MS SQL Server 7 and Sybase
ASE 12.5.3. Both are running on Windows. We need to do a one-off data
migration in both directions between the two RDBMSs and we will are
considering using BCP. Is the native format (-n) compatible between the
Sybase version of BCP and the MS SQL 7 version? i.e. if we BCP out from ASE
using the -n option, can we BCP into a tables of tha same structure in MS
SQL 7 (and vice versa)?
If not, I guess we have to use character format (-c) but I suspect that we
will run into some character set issues: MS SQL Server's default character
set is iso-1 (according to sp_helpsort but CP1252 according to MS Enterprise
Manager) and ASE's default character set is cp850.
Does anyone have any experience of doing anything similar?
Kind regards,
Tim
| |
|
| Hi, I don't kow the specific answer to your question, but I just wanted to
mention that 12.5.3 comes with a new PowerTransfer utility that is used to
transfer data from MS SQL Server to ASE and it may help you.
Cheers
"Tim Mottershead" <tim. mottershead@sportodd
s.nospamremoveme.com> wrote in
message news:42513a38@forums
-2-dub...
> Hi,
>
> We are working on a data migration project using MS SQL Server 7 and
Sybase
> ASE 12.5.3. Both are running on Windows. We need to do a one-off data
> migration in both directions between the two RDBMSs and we will are
> considering using BCP. Is the native format (-n) compatible between the
> Sybase version of BCP and the MS SQL 7 version? i.e. if we BCP out from
ASE
> using the -n option, can we BCP into a tables of tha same structure in MS
> SQL 7 (and vice versa)?
>
> If not, I guess we have to use character format (-c) but I suspect that we
> will run into some character set issues: MS SQL Server's default character
> set is iso-1 (according to sp_helpsort but CP1252 according to MS
Enterprise
> Manager) and ASE's default character set is cp850.
>
> Does anyone have any experience of doing anything similar?
>
> Kind regards,
>
> Tim
>
>
| |
| Stefan Lobet 2005-04-06, 8:03 pm |
| Hi,
We have built a system that BCP's data out of our ASE 12.5 and then into SQL
Server 2000 for archiving. It's basically a bunch of procedures, views and
batch files.
We have not tried to use the native format as we've found that using
character format actually uses less space in the resulting .dat files.
Remember to add the parameter "-r \r\n" when you BCP out of (or into) ASE
(in character format), as by default it only writes (or expects) a newline
at the end of each line and SQL Server works with carriage return and
newline.
Our SQL server database is using SQL1_Latin1_General_
CP1_CI_AS; the ASE
server is using cp850. So far (touch wood) we have not had any character
set issues, but then again our data is mainly numbers and whatever text we
have is always English.
Hope this helps,
Stefan Lobet
"Tim Mottershead" <tim. mottershead@sportodd
s.nospamremoveme.com> wrote in
message news:<42513a38@forums-2-dub>...
> Hi,
>
> We are working on a data migration project using MS SQL Server 7 and
Sybase
> ASE 12.5.3. Both are running on Windows. We need to do a one-off data
> migration in both directions between the two RDBMSs and we will are
> considering using BCP. Is the native format (-n) compatible between the
> Sybase version of BCP and the MS SQL 7 version? i.e. if we BCP out from
ASE
> using the -n option, can we BCP into a tables of tha same structure in MS
> SQL 7 (and vice versa)?
>
> If not, I guess we have to use character format (-c) but I suspect that we
> will run into some character set issues: MS SQL Server's default character
> set is iso-1 (according to sp_helpsort but CP1252 according to MS
Enterprise
> Manager) and ASE's default character set is cp850.
>
> Does anyone have any experience of doing anything similar?
>
> Kind regards,
>
> Tim
>
>
| |
| Tim Mottershead 2005-04-07, 8:03 pm |
| Hi Stefan & Dave,
Thanks very much for both your contributions which will be invaluable.
Regards,
Tim
"Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
news:42540056$1@foru
ms-1-dub...
> Hi,
>
> We have built a system that BCP's data out of our ASE 12.5 and then into
SQL
> Server 2000 for archiving. It's basically a bunch of procedures, views and
> batch files.
>
> We have not tried to use the native format as we've found that using
> character format actually uses less space in the resulting .dat files.
> Remember to add the parameter "-r \r\n" when you BCP out of (or into) ASE
> (in character format), as by default it only writes (or expects) a newline
> at the end of each line and SQL Server works with carriage return and
> newline.
>
> Our SQL server database is using SQL1_Latin1_General_
CP1_CI_AS; the ASE
> server is using cp850. So far (touch wood) we have not had any character
> set issues, but then again our data is mainly numbers and whatever text we
> have is always English.
>
> Hope this helps,
>
> Stefan Lobet
>
> "Tim Mottershead" <tim. mottershead@sportodd
s.nospamremoveme.com> wrote in
> message news:<42513a38@forums-2-dub>...
> Sybase
> ASE
MS[color=darkred]
we[color=darkred]
character[color=dark
red]
> Enterprise
>
>
|
|
|
|
|