1. I import the DB in the DDT. I call this DB version 1 and I deploy it to customers.
2. I make changes to the DB, but not using the DDT. Mostly with scripts, and the SQL Server Management Studio. This is version 2 of the DB. I import the DB to the DDT again. By deploying this new package, will the DB modified correctly?
Can I use this method of just importing the DB to the DDT with every new version of the DB I wish to deploy? Will it work? I need this because changes might happen to the DB schema by more than one people, not everyone has the DDT installed and most of those people got used to modifying the schema using SQL Managment Studio or MS Access (for SQL 2000).
Thank you for your time.