Porting table structures to SQL server

  • I am using a third-party (proprietary) database for my database application. I am now looking to port it to SQL server MSDE. Are there any tools available which can analyze my source database tables and create the equivalent CREATE TABLE ... statements which can be executed on SQL server?

    Thanks,

    Krishnan

  • Hi there,

    What type of DB is the proprietary structure using?  DB2?  xBase? Oracle? 

    The difficulty of porting the table strucutres depends on the current DB.  Also depending on the source, the availability of tools may be very good or perhaps not so good.

    Wayne

  • Hi,

    The database was developed by me long time ago! It has an ODBC interface. So, I am looking at a tool which can be used against any ODBC/OLEDB source.

    Krishnan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply