I have a database in VFP. How to generate a database in Sql Server with same
structure? Is there any tools?

Hi Nick

Assuming VFP = Visual fox pro, Can you not use the upsizing wizard ?


Show quoteHide quote

Hi Nick,

Besides the Upsizing Wizard that Reg mentioned, you can run GenDBC.prg on
your database and use the SQL code it generates (Create Table, etc.) to
create a SQL Server database. You'll need to edit it a little since VFP's
SQL implementation is slightly different than T-SQL.

Show quoteHide quote

random select a row based a weight column.
Timeout expire
Optimize this query
store results over network
Variable table name in a cursor declaration