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

> > 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
> Hi,
> 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.
> www.marathongriffincomputers.com

Good news for the command line support. Shall give it a try.


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