Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: Nilson Rishi
  Where is Nilson Rishi?
 Nilson Rishi
Subject: RE: xSQL command line
Thread ID: 331042 Message ID: 331096 # Views: 48 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 26, 2011 7:42:00 PM         

> xSQL is very helpful for MS SQL Server database structure upgrades.
> However, I find I must open xSQL manually and then compare 2 databases and then generate scripts to upgrade the old database. These 3 steps must be done manually now. It is ok to make upgrade for only one user. However, when there are more users, I have to repeat these manually for their updates.
> Thus, I want to know if I could use commands from VFP to programmatically control the xSQL so that these steps could be done automatically without my manual handling?
> If not, is there a similiar tool that could do this?
> Happy new year and Mery Chistmas
> Regards,
> Nilson

All I know is xSQL does support command line sytax so it maybe possible to run these commands from within VFP. However, sounds like a lot of programming work to me.
Pete "the IceMan", from the Great White North of Canada.


xSQL command line Posted by Nilson Rishi @ 12/26/2011 5:31:04 AM
RE: xSQL command line Posted by Pete Sass @ 12/26/2011 7:42:00 PM
RE: xSQL command line Posted by Nilson Rishi @ 12/27/2011 6:36:45 AM
RE: xSQL command line Posted by Cetin Basoz @ 12/27/2011 4:26:08 PM
RE: xSQL command line Posted by Nilson Rishi @ 12/30/2011 9:26:42 AM