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