How to Update Database SQL express DB
-
we have written program in C#. now when we change the database(in sql express 2008)
sp OR view OR add new table OR delete table OR ....how can update the old customer DB within the newest one without changing the data in customer DB. in other word :the customers have previous application and database (full with their specific data). Now a new version is ready and the customer gets the update. In the mean time we made some modification on DB (new table, columns, maybe an old column deleted, or whatever). I’m pretty new in Linq and also SQL databases and my first solution can be: I check the applications/databases version and implement all the changes step by step comparing all tables, columns, keys, constrains, etc. (all this new information I have in my dbml and the old I asked from the existing DB). And I’ll do this each time the version changed. But somehow I feel, this is NOT a smart solution so I look for a general solution of this problem. -
we have written program in C#. now when we change the database(in sql express 2008)
sp OR view OR add new table OR delete table OR ....how can update the old customer DB within the newest one without changing the data in customer DB. in other word :the customers have previous application and database (full with their specific data). Now a new version is ready and the customer gets the update. In the mean time we made some modification on DB (new table, columns, maybe an old column deleted, or whatever). I’m pretty new in Linq and also SQL databases and my first solution can be: I check the applications/databases version and implement all the changes step by step comparing all tables, columns, keys, constrains, etc. (all this new information I have in my dbml and the old I asked from the existing DB). And I’ll do this each time the version changed. But somehow I feel, this is NOT a smart solution so I look for a general solution of this problem.jojoba2011 wrote:
delete table
combined with
jojoba2011 wrote:
without changing the data in customer DB
Seems like two opposing requirements. You need to review this. Usually when schema updates are deployed to an exisiting database,
ALTERbecomes your friend. But each change needs to be analyzed and understood for it's impact. :)Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
jojoba2011 wrote:
delete table
combined with
jojoba2011 wrote:
without changing the data in customer DB
Seems like two opposing requirements. You need to review this. Usually when schema updates are deployed to an exisiting database,
ALTERbecomes your friend. But each change needs to be analyzed and understood for it's impact. :)Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
thanks for reply! but i wanna to update my database (it should compare the old database with the Newest one and update the old one ...
if need Add/Update/Delete SP,View,table,schema,...) in other word :the customers have previous application and database (full with their specific data). Now a new version is ready and the customer gets the update. In the mean time we made some modification on DB (new table, columns, maybe an old column deleted, or whatever). I’m pretty new in Linq and also SQL databases and my first solution can be: I check the applications/databases version and implement all the changes step by step comparing all tables, columns, keys, constrains, etc. (all this new information I have in my dbml and the old I asked from the existing DB). And I’ll do this each time the version changed. But somehow I feel, this is NOT a smart solution so I look for a general solution of this problem.