>THE SITUATION
>==============
>I have a database (with lots of data) in VFP 5, that I'm upsizing to SQL Server 6.5 using the SQL Server Upsizing Wizard.
>I upsized it, and it worked great.
>I looked at the Upsizing report, and found the saved code to create the upsized tables, but not the code to move the data.
>
>QUESTION
>=========
>I want to move the data over to the server again, but not change the structure of the SQL 6.5 tables (I made some custom data types that will get inconveniently wiped out by re-upsizing).
>
>Is there anywhere I can find that code that the upsizing wizard uses to move the data?
>Could someone provide me with an example of how to do that easily?
>(I'm VERY familiar with VFP & SQL, and moderately familiar with SQL Server and TSQL.)
>
>Or should I just get off my lazy ass, and write a program that goes through all the tables I want to move data for, SCANs them, and line-by-line uses SQLEXEC() to INSERT each row?
>
>Thanks much in advance.
>
>Pol Stafford
>
>Please direct replies via EMail to:
>paul@caseTrakker.com
It seems as though the simplest and quickest means of moving
the data would be to create a remote view, manipulate the
tables in VFP, and do a tableupdate(), rather than trying to
screw around with SQL.
Bill Benton
SSTi
Mt. Laurel, NJ
Bill Benton
Senior Systems Analyst
Nuvell Financial Services