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.

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

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

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

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

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.

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

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

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