> >
> > What do you mean exactly:) Copy & paste? SQLExec? Probably you meant upsizing wizard which I didn't like the last time I tried (before SP2).
> >
> > Cetin Basoz
>
> Well I do have a C# application which can work with VFP databases and with MS SQL Server. Now I like to convert my SQL script for creating VFP database to create a MS SQL Server database, so I can create the data structure on MS SQL Server as I did formerly on VFP databases.
>
> Thanks for your support
>
> antoschka

Antoschka,
NEVER use ANY wizards for your production.
They are good when you begin with programing just to learn HOW to do some things, but they are NOT good when you start to built production application.
Maybe Upsizing wizard for VFP9 SP2 is much better than others (I don't know I never used it).
But creating SQL Server database and tables with it is NOT my suggestion.
Create your database manually with ALL tables, relations and Indexes. Even if you have hundred of tables that will cost you only a few days.
During that period you also could recheck if that is the optimal structure of Database and redesign it.
Then you could script it and use that script in your application.
Believe me that would takes some days for creating it, but will save MONTHS for debugging and test IF everything is right.


-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.