Search code examples
sql-serverdatabaseexportmaxdb

MaxDB Data and Schema Export to SQL Server 2005/8

I am tasked with exporting the data contained inside a MaxDB database to SQL Server 200x. I was wondering if anyone has gone through this before and what your process was.

Here is my idea but its not automated.

1) Export data from MaxDB for each table as a CSV. 2) Clean the CSV to remove ? (which it uses for nulls) and fix the date strings. 3) Use SSIS to import the data into tables in SQL Server.

I was wondering if anyone has tried linking MaxDB to SQL Server or what other suggestions or ideas you have for automating this.

Thanks. AboutDev.

Solution

  • I managed to find a solution to this. There is an open source MaxDB library that will allow you to connect to it through .Net much like the SQL provider. You can use that to get schema information and data, then write a little code to generate scripts to run in SQL Server to create tables and insert the data.

    MaxDb Data Provider for ADO.NET