Hi EE -
My Boss, has tasked me with finding out procedures for converting 10 or so tables from an SyBase ASE v.11.9.26
Database (linux box) to a MSSQL Server 2005 friendly set of tables?
I have been reading SSMA for SyBase :
The SSMA above sounds simple: a) I install the program SSMA and b) then launch it. c) Login to my SyBase DB and d) then tell it (using built in SSMA GUI tools) to convert (extract) these 10 tables. e) I then open my MSSQL tool (whatever the customer is using) and f) grab this object that I extracted and g) import it in to the MSSQL Server 2005 DB.
The DTS above sounds mor like I have to be moving data around within MSSQL system. But I read another post here :
this sounds like I could use the DTS to convert the tables, mentioned above.
All assistance is appreciated.