how to update tables' structures keeping current data
- by Leon
I have an c# application that uses tables from sqlserver 2008 database (runs on standalone pc with local sqlserver).
Initially i install database on this pc with some initial data (there are some tables that application uses and the user doesn't touch).
The question is - how can i upgrade this database after user created some new data without harming it (i continue developing and can add some new tables or stored procedures or add some columns to existing tables).
Thanks in advance!