StrataFrame Forum » .NET Forums » General .NET Discussion » Shot in the dark. VFP/Stonefield to SQL Server Tool?

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

Keith Chisarik — Thu, 09 Jul 2009 08:37:57 GMT

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.

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

Michel Levy — Thu, 09 Jul 2009 08:37:57 GMT

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

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

Charles R Hankey — Wed, 08 Jul 2009 14:34:46 GMT

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

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

Aaron Young — Tue, 07 Jul 2009 03:32:51 GMT

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

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

Trent L. Taylor — Mon, 06 Jul 2009 15:36:18 GMT

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

[codesnippet]bcdedit.exe /set {current} nx AlwaysOff[/codesnippet]

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

Keith Chisarik — Mon, 06 Jul 2009 15:23:08 GMT

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

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

Trent L. Taylor — Mon, 06 Jul 2009 15:15:26 GMT

[quote]and DEP keeps killing the process.[/quote]

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.

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

Keith Chisarik — Mon, 06 Jul 2009 15:06:47 GMT

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

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

Edhy Rijo — Mon, 06 Jul 2009 15:03:59 GMT

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.

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

Keith Chisarik — Mon, 06 Jul 2009 14:54:01 GMT

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.

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

Edhy Rijo — Mon, 06 Jul 2009 14:47:46 GMT

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.