Hey all, I've got a question for you. What would be the best way to set up a set of srcipts to create\Update the databse when my app is installed?
The problem is that I obviously can't just drop the database cause if the database is already installed then the client would lose all his data. I need a way to update the collumns in each table if they change but still keep the clients data. Stored Procedures, Views and Triggers are easy cause these I can drop then create again but tables are a bit more complex. I thought of writing something to the effect of : USE Information_Schema; IF (SELECT Table_Name FROM Tables WHERE TableName = '<TableName>' AND Table_Schema = '<Database>') IS NULL THEN BEGIN {Create Table} END; ELSE BEGIN {Alter Table} END; END IF; Is there not a better way of doing things? We want to try and create\update the database through scripts which can then be deleted instead of writing an app. Any help would be greatly appreciated Thanx, Luke