Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
export Sybase ASE database to MSSQL
- Thread starter holdahl
- Start date
Yes bcp is the best to only transfer the data
You can also use MS SQL DTS to import the Sybase data provided you installed the Sybase odbc driver on the MS SQL server.
But be careful with large numbers. it fails with numbers that have more than 16 digits (might be 18 - can't remember)
You can also use MS SQL DTS to import the Sybase data provided you installed the Sybase odbc driver on the MS SQL server.
But be careful with large numbers. it fails with numbers that have more than 16 digits (might be 18 - can't remember)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question