Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2012-05-03 : 14:38:44
|
| Hi folks,Does anyone know if it is possible to import a SyBase (adt, adi, adm) database into SQL Server and what the requirements may be?Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 14:40:01
|
| you want to import db as a whole or just some data from it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2012-05-03 : 14:41:04
|
| Just read the data. |
|
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2012-05-03 : 14:43:10
|
| http://www.swissql.com/products/sybase-to-sqlserver/sybase-to-sql-server.html |
|
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2012-05-03 : 14:45:29
|
| You can use the SSIS to import the data from another database in sql server database |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 14:47:10
|
quote:
Originally posted by WindChaser
Just read the data.
multiple options1. SSIS package2. OPENROWSET3. Linked server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2012-05-03 : 15:09:05
|
| I'm not totally clear on how to proceed. First, by SSIS, I suppose that you mean SQL Server Import & Export Wizard. If so, what type of data source would I select? Do I need a particular ODBC driver or something? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Import from SyBase