Pull data from an Advantage Database 1

[checkai]

Has anyone done this? I need to pull across tables and data from an Advantage database into a SQL Server DB...

Thanks,
Dustin

 

[JayKusch]

I believe you may have a couple of ways to accomplish this though you will have to use a intermediate holding arear for the data.

You could port the data/tables to a Microsoft Access Database or port the info to CSV files(Comma Seperated Values) which are more or less text files.

Then you could import that data/tables from Access or the CSVs using the import tool SQL Server uses. This would really be DTS(Data Transformation Services)

I do not beleive there is a native Advantage data pump feature that will move the schemas and data stright into SQL Server.

Thanks

J. Kusch

 

[checkai]

Thanks J,

I have imported them from .csv files into SQL using a DTS...

 

[checkai]

I am having more issues with this...I get an error in the DTS stating something about open quotes, etc...

has anyone seen a way to do this yet with an odbc driver or something?

dlc

 

[kokkik]

You need to
1. have advantage client installed
2. Configure client interface driver pointing to advantage db.
3. Configure a ODBC DSN for it
4. Use DTS and stating the source from the DSN