Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've been given a Sybase .db file by a client and I need to import that into a new SQL Server database so that I may see the data as well as the tables and their relationships, any ideas on how that might be done shall be really appreciated :)

share|improve this question

migrated from stackoverflow.com Oct 3 '12 at 12:59

This question came from our site for professional and enthusiast programmers.

    
You need a Sybase server –  Mark Oct 3 '12 at 12:03

3 Answers 3

If it's a dump file, load it into a development database using the load command. Alternatively you can use a working production system to obtain a new dump. You can the transfer it from the sybase db to the ms sql server db using Microsoft's SSMA tool.

The download link for SSMA is below. Microsoft SQL Server Migration Assistant v5.3 for MySQL

share|improve this answer
    
Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database to SQL Server! not for sybase –  imanabidi Jul 17 at 12:31
    
@imanabidi why is it not good for sybase ? I have been using it for all my migrations from sybase to SQL Server and it works excellently. –  Kin Jul 17 at 14:27
    
thank you. i mislead-ed by description of the tool –  imanabidi Jul 19 at 12:19

Use the Sybase ddlgen utilitly to extract the database structure, datatypes, etc. Then use the Sybase bcp utility to extract the data from the Sybase database. Once you have those two things, you can build the database in SQLServer, and import the data.

share|improve this answer

Since both Sybase and SQLServer share the same SQL dialect (T-SQL), I'd generate the DDL statements from the existing database (it will require a Sybase server) to build the SQL Server database and the an SSIS task to copy data between databases.

I don't know if it is possible to SQLServer to just open a Sybase file, but, albeit the same origins, I don't believe there's any kind of binary compatibility between inner formats of this two DBMS.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.