Very Computer

Hi out there,

I'm new to FoxPro.
I have to migrate abourt 150 FaxPro 6.0 *.dbf tables to MSSQL 8.00

I think, I have to do that in 2 steps:
1 - Convert FoxPro *.dbf to DBASE IV
2 - Import DBASE IV into MSSQL 8.00

I want to do that in a script.

But, I don't know the commands and if this is the right way to do that.

Any suggestions, examples would be great!!

With kind regards,

Herman

Herman,
Why do you need to convert to dBase first? Many people simply import VFP tables directly into SQL
Server databases - either using the VFP Upgrade Wizard or the SQL Server DTS capabilities.

Rick

Quote:> Hi out there,

> I'm new to FoxPro.
> I have to migrate abourt 150 FaxPro 6.0 *.dbf tables to MSSQL 8.00

> I think, I have to do that in 2 steps:
> 1 - Convert FoxPro *.dbf to DBASE IV
> 2 - Import DBASE IV into MSSQL 8.00

> I want to do that in a script.

> But, I don't know the commands and if this is the right way to do that.

> Any suggestions, examples would be great!!

> With kind regards,

> Herman