StrataFrame Forum

Shot in the dark. VFP/Stonefield to SQL Server Tool?

http://forum.strataframe.net/Topic23752.aspx

By Keith Chisarik - 7/6/2009

I have well over a hundred tables that need to be created in SQL Server from VFP. I am about to do this with COPY Stucture and SMO, unless someone here knows of a magic tool to do this that I cannot find via the magic of Google. I also have the table definitions in Stonefield metadata.
By Edhy Rijo - 7/6/2009

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.
By Keith Chisarik - 7/6/2009

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.

By Edhy Rijo - 7/6/2009

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.
By Keith Chisarik - 7/6/2009

thanks for the kind offer, Ill let you know shortly. I want to make sure that will work for me.
By Trent L. Taylor - 7/6/2009

and DEP keeps killing the process.




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.
By Keith Chisarik - 7/6/2009

I set it as an excpetion and it still did it, trying to remember/Google the way to turn it off globally now.
By Trent L. Taylor - 7/6/2009

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



bcdedit.exe /set {current} nx AlwaysOff
By Aaron Young - 7/6/2009

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
By Charles R Hankey - 7/8/2009

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
By Michel Levy - 7/9/2009

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).