Hi,

Upsizing wizard is shipped with VFP, but didn't run fine when import data, and had ennoying bugs. I've corrected the main bugs and now it's OK.

Tables definitions, index definitions, RI, triggers, and data are well upsized in SQL server. I've used it agains hundred tables, with more than 500000 records by table

you can download it from CodePlex, in the french localized version, with the source (you will see all locs strings are now in h files, with original english strings - just modify and recompile).

I do / have done a lot of VFP - SQL conversions and the best tool I've found so far is called Full Convert Enterprise

from Spectral Core



http://www.spectralcore.com/fullconvert/index.php?app=fc-ent&trial=0&from=helpweb

Just in case this doesn't work out, Edhy's suggestion is a good one as I came from the same direction - VFP to xCase, xCase to SQL, SQL to DDT.



Aaron

I think this will do it....should be really close if not

I set it as an excpetion and it still did it, trying to remember/Google the way to turn it off globally now.

Keith Chisarik

Is there a reason that you cannot turn off DEP? I turn it off by default any more as it gets in the way more than it ever helps. But even if you just trn it off and then turn it back on, you could at least get through this cycle.

thanks for the kind offer, Ill let you know shortly. I want to make sure that will work for me.

Keith Chisarik

That is why I offer to import the VFF tables using xCase, so you can create them in a temp DB in MS-SQL, so then you can import them in the DDT from MS-SQL.



The offer still stand, so just let me know if you need it.

Edhy Rijo

Eventually I need the metadata in DDT. I know the DDT imports VFP tables as well, but it isnt working. It is only "seeing" three of the 30+ tables in the database, and DEP keeps killing the process.

Also I have an existing DDT definition that I need to add to, it seems like the DDT import creates a new database.

Ill check out xCase as an alternative. My thought if I cant get the DDT to work was to create the tables via SMO, then import them as the SQL Import seems to work a tad better.

Keith Chisarik

Hi Keith,



You can use xCase if you have it, to import from VFP and then create the MS-SQL script.



If you do not have xCase, then put your VFP tables in a zip file on your ftp and give me access to it, I will have it done in xCase for your and send you the script.

Edhy Rijo