Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Cetin Basoz
 To: Nilson Rishi
  Where is Nilson Rishi?
 Nilson Rishi
Subject: RE: xSQL command line
Thread ID: 331042 Message ID: 331183 # Views: 46 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 27, 2011 4:26:08 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

You may want to check and use redgate tools. Data compare generates scripts that you can either run from VFP or redgate to update multiple servers. Like xTools it is not for free and also included in SQL developer bundle and SQL toolbelt packages.

Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down

Support Wikipedia


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