Home > IT Answers > Development > sql scripts
JARON
5 pts.
 sql scripts
Scripts, SQL, SQL scripts
Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write other ways script than using 'alter', becoz its like im having the database for the first time and our clients have the older version... Any Ideas?? 10x in advance

Software/Hardware used:
ASKED: June 5, 2008  9:12 AM
UPDATED: June 5, 2008  7:57 PM
RELATED QUESTIONS
Answer Wiki:
When writing change scripts you'll need to know what version of the schema the customer has. Once you do you can write the scripts to add in the new database objects. You'll need to use CREATE and ALTER commands to create the new objects and update the existing objects.
Last Wiki Answer Submitted:  June 5, 2008  7:57 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _