Upgrade existing database
davida
Posts: 2
If I select "Upgrade an existing database" what does this do?
I thought this would compare the differences between the two databases and apply any changes. However, I keep getting an error saying "... <name> already exists in current database".
Scenario:
We have many clients on different versions of a database. When we create a new version of the database can SQL Packager handle the upgrade of multiple versions?
Thanks,
Dave
I thought this would compare the differences between the two databases and apply any changes. However, I keep getting an error saying "... <name> already exists in current database".
Scenario:
We have many clients on different versions of a database. When we create a new version of the database can SQL Packager handle the upgrade of multiple versions?
Thanks,
Dave
This discussion has been closed.
Comments
When you generate an upgrade package, SQL Packager creates a schema and a data difference script that will make the database you're 'upgrading' the same as the source database.
This issue you're probably having is that you are trying to run an upgrade package against a third database. That will probably not work because the package has no knowlegde of the source database built-in. It only contains a differential script between the two databases that you compared to make the upgrade package.
Please let me know if you have any more questions about this.