Importing 300 DBF files in SQL Server

Category: sql server datamining


Varun1976077 on Thu, 19 Feb 2015 17:35:42

From a client I have received a zip file, which according to him is the SQL server backup. But this zipfile have 300 DBF files. Do you know of a quick way to import all of them into SQL server? Normally there is a .bak file as far I am aware of Microsoft technologies.


Sreejith G on Thu, 19 Feb 2015 17:42:24

Doesn't sound like backup file, looks like some sort of structured data output. You may need to clarify it from client. Once you identify the format you can use BCP and automate process to import all to a table in database.



Tom Phillips on Thu, 19 Feb 2015 18:12:59

.DBF files are normally DBase files, not SQL Server.  Every DBase file is a unique table.

You would need to import them one at a time into tables in SQL Server.