Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vivek Deodhar
  Where is Vivek Deodhar?
 SANGLI
 India
 Vivek Deodhar
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: mysql structure update
Thread ID: 395421 Message ID: 395455 # Views: 48 # Ratings: 5
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, January 15, 2014 6:31:12 AM         
   


> HI
>
> Need mysql structure update without drop table. because if i drop table all data also drop.
>
> i need my existing table still alive and missing fields add in table so that table data also saves and missing fields add in table
> how is possible
>
> i found many code from google uncle but all code first drop table and make new. that i lost data.
>
>
>
> Regard
> Pratik
>
> Learning never ends

Hi,

I am using a freeware utility for exactly same purpose.
In my experience, it does a good job of comparing two schemas (one maybe your development machine schema and another at client's computer). It also accepts remote host for one schema and local host for other, so this is ideal for the purpose.

You can get it here.

http://www.softpedia.com/get/Internet/Servers/Database-Utils/Mysql-Structure-Compare.shtml

Vivek

Live wisely... because in real world, there is no Ctrl + Z!

ENTIRE THREAD

mysql structure update Posted by Pratik Singh @ 1/14/2014 8:01:32 PM
RE: mysql structure update Posted by Tore Bleken @ 1/14/2014 8:12:07 PM
RE: mysql structure update Posted by Pratik Singh @ 1/14/2014 8:27:49 PM
RE: mysql structure update Posted by Pete Sass @ 1/14/2014 8:21:38 PM
RE: mysql structure update Posted by Vivek Deodhar @ 1/15/2014 6:31:12 AM