How to load Sybase ASE 12.5.3 dumps into SQL Server 2005

Is this possible? How would one go about it?
FreezingPeteAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris MConsulting - Technology ServicesCommented:
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.
0
Chris MConsulting - Technology ServicesCommented:
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.
0
FreezingPeteAuthor Commented:
Almost there, how do I export an entire database to a CSV flat file?
0
FreezingPeteAuthor Commented:
or can i somehow just use the dumps instead?
0
Chris MConsulting - Technology ServicesCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.