Importing Foxpro files to sql server

[jshanoo]

Hi all,
i have some where around 273 foxpro tables. Now my company decided to import to sql server. is there any single method to import all the dbf structures to sql server and create the correponding tables in sql server



*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[MarkSweetland]

SQL Server should be able to import the structure and data through the Server Data Transformation Services (DTS) in the Enterprise Manager.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[jshanoo]

Hi Sweetland,
DTS i know, but for that u have create same table in sql and import


*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[jshanoo]

oops i pressed the submit soon.
my foxpro tables extension is in 'smi' not dbf so the DTS is not reconizing it. any other alternative for this

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[MarkSweetland]

Set up a system DNS on your machine pointing to the FP file and Select "Other ODBC Data Source" in the DTS as the Data Source. You should be able to select the DNS as the data source.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[jshanoo]

Hi sweetland,
i tired ven that option also, even in that case it sis not detecting the 'smi' foxpro files

*** Even the Best, did the Bad and Made the Best ***

John Philip