Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Unanswered: Trying to load a sysbase database into SQLserver, need help

    Hi I'm a bit new to this, but I have been give some flat file from a sysbase database and have been asked to import it into our SQLserver database.

    However I'm not sure what to do, I have been given a .db and .log . but SQL server doesn't like either of these, is their something I should do to make it compatable? First tie I've ever look at Sybase so please use short words, Thanks Ed

  2. #2
    Join Date
    Nov 2003
    Posts
    30
    Extract the data from sybase database in flat file format. convert the flat file to excel format.Then using import data utility of SQL server upload the file into respective tables...

  3. #3
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Ask whether its an ASA or ASE database? Sybase has 3 databases

    ASA - Desktop & mobile db
    ASE - OLTP
    IQ - Datawarehousing

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Post

    Quote Originally Posted by Nixies
    Hi I'm a bit new to this, but I have been give some flat file from a sysbase database and have been asked to import it into our SQLserver database.

    However I'm not sure what to do, I have been given a .db and .log . but SQL server doesn't like either of these, is their something I should do to make it compatable? First tie I've ever look at Sybase so please use short words, Thanks Ed
    You can't link a ASE database on a MS-SQL server.

    You must
    1) create your DB on MS-SQL
    2) extract the DDL of all your Sybase objects using Sybase Central, PowerDesigner or any other tool allowing reverse engineering
    3) re-execute the sql script on MS-SQL. If needed, fix the issues regarding the difference between both T-SQL.
    4) export the data using bcp -c from ASE
    5) import the data using MS bcp -c to MS-SQL

    Remark : stupid idea to pass from ASE to MS-SQL ;-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •