Hi,

is anyone aware of a way to export a sqlserver 2000 database structure
(not data) to a foxpro dbf.
We dont have foxpro installed on our system.

Thanks.

Not that I know. DTS is more about transferring data more than Structures
although will do transfers between SQL Servers. You will be able to create
suitable tables on Faxpro at design time in your package.

If you want to take a SQL Server structure (the whole thing i.e. indexes,
functions) I think you will be out of luck

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



<aamirghanchi (AT) yahoo (DOT) com> wrote

Hi!

You can use CREATE TABLE through the FoxPro OLE DB data provider
(downloadable from msdn.microsoft.com/vfoxpro/downloads/updates). You'll
need to look at the Fox documentation in the MSDN Library for the exact
syntax as it's slightly different from T-SQL's syntax.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy (AT) cindywinegarden (DOT) com


<aamirghanchi (AT) yahoo (DOT) com> wrote