DBF to be attached in sqlserver2000/2005

Hi, Everybody

Please tell me the detailed procedure for having a *.DBF file attached to sqlserver 2000 or 2005.

I just want this file which is of visualfoxpro - DBF to be in sqlserver...........

thanks and regards,

Vishwanath.

Hey,

I don't believe SQL can import new database structures. You may, through DTS/SSIS, be able to copy the structure/data over, and that would create a SQL-compliant structure, depending on what was in the tables. I thought foxpro was more of an object-oriented database, which is not what SQL is...

|||

Hi Vishu

A lot depends on what you mean by "attached." You can use a linked server to access Fox data in SQL Server. You will need the FoxPro and Visual FoxPro OLE DB data provider, downloadable from a link at http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx . If you have a DBC (Database Container) in the directory where the Fox tables are then point your connection string to it. Otherwise, use the "Free Table" option and just point the connection string to the directory where the DBFs are. When you select data from the linked server use code like Select MyField From MyLinkedServer...MyTableName without using ".dbf" on the end of the table name.

|||

Hi!

Visual FoxPro is both an ODBC/OLE DB compliant database and a fully object-oriented development tool. In addition to using DBFs (Fox tables) as the data store you can use an Access MDB or SQL Server. In either the case of SQL Server it would be used as a front end in the same way as VB or C#.