how to update tables' structures keeping current data

Posted by Leon on Stack Overflow See other posts from Stack Overflow or by Leon
Published on 2011-01-02T05:41:07Z Indexed on 2011/01/02 5:53 UTC
Read the original article Hit count: 275

Filed under:

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!

© Stack Overflow or respective owner

Related posts about sql-server