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
Subject: xSQL command line
Thread ID: 331042 Message ID: 331042 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 26, 2011 5:31:04 AM         

I now made a program that could automate the database structure updates on SQL SERVER. And thus the problem gets solved.
To make the program, I used command lines both from SQLCMD and xSQL.

Happy new year

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



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