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  Import/Export (DTS) and Replication (2000)  Getting data from Sybase 11

Author  Topic  Kristen Test 22859 Posts Posted - 2004-08-24 : 13:21:16 I need to get data out of a Sybase 11 database - which came bundled with an application. The only things available seem to be command line iSQL and BCP. The BCP seems to work nicely, but I could do with some blank tables to import the data into - any ideas? Otherwise I wind u with [Col001], [Col002] and all as varchar(8000 I don't have an ODBC connection available (its a production server, so I don't want to go messing around trying to make one when all I know is the database name, user ID and password ... but) I suppose I could knock something up using sysobjects and syscolumns - they look to be about the same as MS SQL Server equivalents. Kristen