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
    
You need a Sybase server –  Mark Oct 3 '12 at 12:03
add comment

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

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

3 Answers

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
add comment

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. http://www.microsoft.com/en-us/download/details.aspx?id=28765

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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