I have written a utility that will - Copy existing data to a back up directory - Update the database including DBF structure/View/Stored procedure - Copy Data from old Database to New Database - Update NEXTK table if new table is added for generating ID.
If U require it, please mail me to [EMAIL PROTECTED] Devendra Jariwala -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Russell Sent: Wednesday, August 13, 2008 11:37 PM To: ProFox Email List Subject: Re: Sending database changes off-site for views On Wed, Aug 13, 2008 at 8:56 AM, John J. Mihaljevic <[EMAIL PROTECTED]> wrote: > Hi all, > > We've got an app running off-site. Whenever I make changes to the structure > of tables on my end, I've been writing little programs using commands such > as ALTER TABLE to make the changes to the structure of the tables on the > user's end. > > But what if I make changes to a view? How do I transfer those changes to > the user's site? --------------------------------------- drop view viewName create view YourSyntaxHere go -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
