Sync MSSQL 2005 Databases in our .NET Application

  • Thread starter Thread starter Optitec
  • Start date Start date
O

Optitec

Hi.

I'm aware that this might have been posted in the wrong forum, but I'm new
here and couldn't find the appropriate one.

My question:


We have a system that is under continues development and our customers all
have different versions of our application.

Recently we thought that it might be time to create an automatic updates but
soon realized that since customers all have different versions their database
structure also needs to be updated.

How can you Sync the database structure? NOT THE DATA. Just the SP's, views,
tables and so on?


We tried that Perpetuum software, but it has too many bugs and causes the
scripts it generates to fail Plus that they've been sold to this Brittish
company I think that doesn't seem to care.



If anyone could point us in the right direction that would be great! :)
/Optitec
 
When the application starts up, you could do some key checks on the db. If
the checks fail then run a method that will add / update the db for that key
check.
 
Checkout RedGates Product line and see if it fits your requirement.

Regards,

Trevor Benedict
 
Back
Top