|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
08-07-2009
| #1 (permalink) |
| | Sync MSSQL 2005 Databases in our .NET Application 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 |
My System Specs |
|
08-07-2009
| #2 (permalink) |
| | Re: Sync MSSQL 2005 Databases in our .NET Application 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. "Optitec" <Optitec@xxxxxx> wrote in message news:BADF29C9-6D3D-41E0-87AB-E62978BF4CBD@xxxxxx Quote: > 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 |
| My System Specs |
|
08-10-2009
| #3 (permalink) |
| | Re: Sync MSSQL 2005 Databases in our .NET Application Checkout RedGates Product line and see if it fits your requirement. Regards, Trevor Benedict "Optitec" <Optitec@xxxxxx> wrote in message news:BADF29C9-6D3D-41E0-87AB-E62978BF4CBD@xxxxxx Quote: > 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 |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| try to update a Microsoft Visual Studio 2005 ClickOnce application after the certificate that you used to sign the installation expires, error message recieved | .NET General | |||
| Running VS 2008 and MSSQL 2005 on a laptop | .NET General | |||
| MSSQL | Vista General | |||
| Sync Pocket PC with Windows Mobile 2005 with Vista Business Ed. | Vista General | |||
| Sync Outlook 2003 with QTEC S200 Windows Mobile 2005 | Vista hardware & devices | |||
