Post reply

migrate from d base to sql server 2005

  • March 5, 2007 at 7:22 am

    #123135

    Need help migrating from d base to sql server 2005.

    Currently googling out for help but your input if any, would be apreciated

    Mike

  • March 6, 2007 at 4:51 am

    #693272

    Mike, can you be more specific? Basically you would create an ODBC connection and DTS the data into SQL Server.

    Each dbase table is a separate DBF file; if it has a memo field then that is also a separate file. Indexes are NDX files; dbase IV added MDX which can hold multiple indexes. The structure is quite like FoxPro if that expands the Google search.

    Dbase is Y2K compliant, dates are stored as yyyymmdd. However there is a "Y2K+1" bug so don't _write_ to a DBF with anything other than dbase.

    Hope that helps.

  • March 6, 2007 at 6:03 am

    #693281

    A whole lot .Sometimes this things come up and since it is a database the DBA automatically has to take charge.

    Have to learn about d base ..

    Thanks again

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

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