What's the quickest way to take vfp tables to sql?

[EzLogic]

I have an app with about 40 tables or so, all in a dbc.

i want to duplicate the same tables and put them on my sql express box.

i dont want to create each table manually in sql.

is there a utility that can import them or duplicate them into sql? same field names, etc..



Ali Koumaiha
TeknoPCS Inc.
Dearborn heights, MI 48127

 

[Olaf Doschke]

It's not only a question of the quantity but also the quality. Perhaps you know already that SQL Server does not know an empty date/datetime and only SQL2008 does have a pure date type (without a time portion). Empty dates should either be converted to some ultimo date, eg 1/1/1900, especially if you have code that does date comparisons, eg date1<date2 with the values, it could be a bad move to switch these empty dates to NULL.

Another problem is, you'll only have the Bit field type, not a boolean/logical field type, but ODBC does convert 0/ to .F./.T.

Ragarding Upsizing VFP to SQL Server I recommend this read:

http://www.code-magazine.com/Article.aspx?quickid=0703052

Bye, Olaf.

 

[EzLogic]

Thanks Olaf, i just want the structure. i already have the code to upload/sync with sql from Rick Strahl.

i will look @ the thread you provided.

Ali Koumaiha
TeknoPCS Inc.
Dearborn heights, MI 48127

 

[Olaf Doschke]

Well, for converting the table structure, you can use XCase, it does reverse and forward engineer database structures and more.

Bye, Olaf.

 

[Nifrabar]

would faq184-3774 be of help?
Just tweak this code a bit might answer you Q
-Batr