<div>
Export data into a comma separated (CSV) file, then use import/export wizard into MSSQL server.<br />
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.<br />

</div>


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.


<div>
Importation of Data into SQL can also be done using SSIS where you write an SSIS job.<br />
For SQL 2005, importation of data using Import/Export wizard is pretty quick and easy.<br />
<br />
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.<br />
<br />
Remember to specify the source file as a flat file, in this case it's your CSV flat file :-)<br />
<br />
Good luck.<br />

</div>


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.


<div>
Almost there, how do I export an entire database to a CSV flat file?<br />

</div>


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


<div>
or can i somehow just use the dumps instead?
</div>


or can i somehow just use the dumps instead?

<div>
<div class="content wysiwyg-content">
Is this possible? How would one go about it?
</div>
</div>


Is this possible? How would one go about it?

How to load Sybase ASE 12.5.3 dumps into SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.