How to load Sybase ASE 12.5.3 dumps into SQL Server 2005

Posted on 2010-03-24
Medium Priority
Last Modified: 2012-05-09
Is this possible? How would one go about it?
Question by:FreezingPete
  • 3
  • 2
LVL 12

Expert Comment

by:Chris M
ID: 28433311
Export data into a comma separated (CSV) file, then use import/export wizard into MSSQL server.
The second option for you is to use BCP on Sybase to export it into a CSV file, then use MSSQL's BCP to import it into SQL server.
LVL 12

Expert Comment

by:Chris M
ID: 28433620
Importation of Data into SQL can also be done using SSIS where you write an SSIS job.
For SQL 2005, importation of data using Import/Export wizard is pretty quick and easy.

In SQL server Management Studio (SSMS), launch the Import/Export wizard by right-clicking on the database where you want to import data and the follow the wizard's steps.

Remember to specify the source file as a flat file, in this case it's your CSV flat file :-)

Good luck.

Author Comment

ID: 28446153
Almost there, how do I export an entire database to a CSV flat file?

Author Comment

ID: 28446194
or can i somehow just use the dumps instead?
LVL 12

Accepted Solution

Chris M earned 1000 total points
ID: 28463202
With BCP, you can export each table one by one into a CSV file.
I think this will do.

The other option for you is to setup Sybase ODBC drivers for Windows, then use SQL server's data transformation services (DTS) and export each object graphically using DTS.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question