-
Junior Member
Sql Scripts
Hi all,
i'm updating a new 'common 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
Last edited by ronaldrahme; 06-05-2008 at 05:43 AM.
Reason: not so clear
-
Re: Sql Scripts
if you need to change the structure then you have to use ALTER.
you can create a different database from the existing ,make the changes and finally redirect the application to the new database.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules