The FREE SQL eXpeditor tool will deploy a new schema over an existing Microsoft SQL Server 2000 database, keeping the data. Only provide the database to be upgraded (Data Source) and the one with the new schema (Structure Source). A new database will then be created, with the new schema, but with the data from the old database. Just as simple as it could be. SQL eXpeditor also features intelligent inter-object dependencies handling, correct handling of changes and usage of SELECT views, and correct handling of changes to char-type UDTs.
||Windows 98/Me/NT/2000/XP/2003 Server