Upgrade existing database

davidadavida Posts: 2
edited October 19, 2005 5:27AM in SQL Packager Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello David,

    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.
This discussion has been closed.