Looking for a good Data migration solution

Hot Topic

SQL Server Memory Settings.
how to data bind in detail
How to get a list of all dimensions within a cube in MDX?
Open_tran in sys.sysprocesses has unexpected count
Lookup transformation problem
Open query error: Invalid data for type "numeric".
SQL standard
Executing a View timesout through Open View
Control/Limit Memory usage
SQL Server Express Edition silently at command prompt

SQL Server

dynamic archiving
Slow backups and restores
Integrated Security doesn't work - "Not associated with a trusted SQL Server connection." Error
Job notification
Semi-Additive Function not aggregrating on non-time dimension
Report not picking up Custom Style Sheet OR HtmlViewer.css changes
Is ProcessAdd done within a transaction mode?
Possible to display RTF from db? Is there a control?
Is it reasonable that a table has 240 fields
Replication

Looking for a good Data migration solution

Hi,

I am trying to create a process that will take data source that has been output from a proprietary ISAM database to import into a SQL database. This particular ISAM system cannot be accessed via OleDB or ODBC. The thing is I want the process to be able to create the required tables based on data structure information that has been somehow encoded into the data source.

Currently the solution I am going with is to spit out a CSV file that has a header with table and data format information followed by rows of actual data that gets parsed by a SQL script however I am sure that Microsoft must have some kind of preferred solution to this kind of problem but I have not been able to find it. I have looked at the the tools that are available when creating a SQL Server DTS package as well as what seems to be available using the new Integration Services but nothing seems to be any better than the solution I just mentioned.

Anyone have any ideas, I am willing to bet there is a much better way of doing this.

Answer this question

Looking for a good Data migration solution

  • CPedersen

    By better, what exactly do you mean Specifically, what is wrong with exporting to a file, and then importing from said file Are you looking for a way to directly access the ISAM source via a custom provider With the information provided, I would say that your solution is simple and effective. That's usually the best choice!

    If you could specify what exactly you would like to avoid in the current solution we discuss this further.



  • The WB

    Ok thanks for the advice. By better I guess I meant that perhaps there was already some kind of Microsoft standard format for encoding metadata along with data which would allow me to use one of the SSIS or DTS standard tools and save me having to write the logic to create the tables and columns. My philosophy is the more code you write the more potential there is for error some where along the line.
  • Looking for a good Data migration solution
Answer this question