HOW I CAN DO "WIZARD UPSIZING" FROM THE SOURCE CODE??

HOW I CAN DO "WIZARD UPSIZING" FROM THE SOURCE CODE??

• SSIS - newbie

  Probably you didn't understand what Alex says (or I didn't understand your question either).
  
  Use the upsizing wizard and in last step select generate code. In generated code browse sql (or sql_uw it was) table and you'd see needed code there. You can tweak the code per your taste and run through SPT or isql,osql.
  

  Or first use DTS and then generate script from SQL server side. You could use it in the same manner.

  
  

• NilsP

  >But now, I have one more question for you...if I studi the Microsoft's upsizing
  >code, and I'll change something it, can I redistribuite my program
  
  I'm not really sure as I haven't looked much into this. Maybe someone else might be able to comment on that.
  
  
  
  >And, do you know, if someone have done something similar
  >Or do you know where I can find a code that do the same thing
  
  No. Unfortunately I do not know of any ready-mad esample.
  

• elledibbi

  I have understand this thing...but I want to know if is possible to have the same results of the wizard upsizing using the fox code... for example
  
  I make my program with my fox database, and then I make the .exe of the program!
  Now, I want a button that, when I click on it, the program imports automatically the fox database to the sql server...with the same procedure of the wizard upsizing (with windows exc...) or completelly automatic procedure!
  
  Do you understand me now
  
  Is it possible
  Do you know where I can find some help
  
  Thank you so much!
  
  
  

• WienerSchnitzel

  Let's see if I understand you. You do not want the upsize procedure code, as Cetin suggested. What you want is to include the interface of the Upsize Wizard in your EXE
  
  If that is the case, you will find the source code for you to study in:
  C:\Program Files\Microsoft Visual FoxPro 9\Tools\xsource\xsource.zip
  
  Look for "vfpsource\wizards\wzupsize".
  
  The code is not very well commented but it is fairly easy to follow. Watch out for Licensing problems. As it is now you cannot redistribute the source. The Microsoft VFP Product Manager has said that they may change this restriction for XSource files in the near future.
  

• GabrielMartin

  thank you!
  
  But...You hanven't understand good wat I must do...
  
  
  I must using foxpro upsizing for upsize a foxpro database to an sql server (MSDE)...and I must do this thing using foxpro code..
  
  
  Thank you
  
  
  

• kdee

  Depending on the number of records you can write your own INSERT INTO statements while traversing your data (SCAN..ENDSCAN) or for bigger sets you can use SQL Server's Data Transformation Services (DTS).
  
  http://www.sqldts.com/
  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql2k/html/dts_overview.asp
  

• PatPennington

  YESSSSSSSSSSSSSSSS!!!!
  
  You have perfectly understand what I want to do!
  
  But now, I have one more question for you...if I studi the Microsoft's upsizing code, and I'll change something it, can I redistribuite my program
  
  And, do you know, if someone have done something similar Or do you know where I can find a code that do the same thing A free code possibly!
  
  Thank you so much!
  
  
  
• HOW I CAN DO "WIZARD UPSIZING" FROM THE SOURCE CODE??