SQL Server Performance Forum – Threads Archive
SQL Server 2005 Import/Export to DBFWe have just recently started using SQL 2005 64 bit Enterprise Edition. We typically do a lot of import/export into/out of SQL to/from .dbf#%92s. We noticed immediately when stepping through the Import and Export Wizard that there wasn#%92t an option for dBase files as the source or destination like there was in SQL 2000. We have been able to use the â€œ.Net Framework Data Provider for Odbcâ€ as a source from our local machines but have an issue with our third party (Extended Systems/Advantage Database) supporting the 64 bit platform so it hinders us from scheduling jobs on the 64 bit server that would use a dBase file as the source. I think that#%92s something we need to follow through with our 3rd party vendor. As far as exporting to a .dbf file, we#%92ve searched around and can#%92t seem to find a solution or recommended procedure to exporting to a .dbf at all. What is the recommended path/solution to import and export to/from .dbf files using SQL 2005. Any help would be greatly appreciated.
Please post this under SQL server 2005 —————————————-