im reposting this as no-one responded to it before ..

me a noob at db conversion & have never worked on sybase.

i wanted to convert Sybase Adaptive Server 6.x DB to SQL Server 2000 format including all its queries,triggs etc.(the tables rnt that advanced, so i guess it wudnt be a big trouble). I tried using the Import/Export Utility of SQL Server but am kind'f of stuck.

this is the current situation:
I have SQl 2000 Server(not configured to work properly) Trial
       Sybase Enterprise Server PC Clients 12.5.2
       Power Designer 10.0
       Power Transfer 10.0
       Infomaker 9.0
my database file "CUSTMR.DB"

Do tell me howto convert the db to SQL Server or any other possible format

also will it be possible to run SQL Server 2000 & Sybase Adaptive Server Side By Side so that the old core application can continue accessing the sybase database wheres my new vb or asp.net application can access both sql server db as well as sybase db coz the older app cant be modified and has other core functions that cant be substituted.

I don't think any of us know- that's why no one replied.

My guess is there is no tool to convert and you will need to re-write everying in SQL server. Then you could use a script to import the data. However, using the two side by side will cause them to go out of sync and you will need to find a way to keep them in sync. Including changes, deletes and new rows in each one of the tables. Your in for quite a bit of work.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I just recently migrated a somewhat large Sybase DB to SQL2k. If you seach M$ site you will find MSDN articles that hi light much of the differences and gotchas.

Things like differences in language:
Sybase: Char_Length = SQL: Len
Sybase: @@SQLStatus = SQL: @@Fetch_Status
DataTime conversions

Using mostly DTS and a bit of Embarcadero - I move the whole system across in about 10 hours - the only re-write I had to do was mostly FIND and REPLACE

_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

hey .. i dont want to rewrite the existing app or anything .. no appending or editing of the current app ..

anyways now that converting the whole db is considered tough .. all i want to do is copy the tables or say import the tables one-by-one or all together into access or sql ...

see the problem with me is ive only worked with access and asp before .. and never with db servers .. and this is sumthin like a project im forced to do .. so anything will be sumthin' for me ..

SQL Server and Sybase used to be thte same company meny moons ago. Then one day, Microsoft left ans started to create a better product. Sybase does not have all of the functionality that SQL Server does. You can not just convert the Triggers and stored procedures from Sybase to SQL Server. The data, that is not a big problem, use DTS and you should be able to move the data without a glitch.

Sybase ASA does not even have the ability to do an

select *
into tablename
from table1

It is limited even on the way some case statements and if statements are written in TSQL.

If you are going from Sybase, chances are you will not be able to downgrade it to Access. Access would not be able to haldle much data.



Sal

yea .. i dont want the triggers .. atleast for the time being ..

I just need either Sybase Adaptive Server Anywhere 6.0.3 or its driver to .. to set-up a dsn .. which im not very familiar with ..
i could find only tutorials on howto setup access dsn's ..

i really need this thing worked out ... creating 74 tables and unloading data into them manually isnt that easy atleast for me ..

so any ideas .. welcome .. so far i cant set-up a dsn or odbc conn .. for sybase .. [b'coz by old db is ASA 6.0.3 & i only have ASE 12.5]

ive however managed to unload the table structure into sql file .. but how do i use it to create tables in sqlserver?? part of which ive pasted here .. http://p2p.wrox.com/topic.asp?TOPIC_ID=18072

Try to create a linked server in SQL Server to the Sybase server. Then do a

Select *
into tablenameinSQLServer
from linkedserver...table1

or something like that. You could alsop just use DTS to do this.



Sal