• SCOTT!

    That's a really hard problem, as I'm sure you're aware. I don't have a good answer. You should start a new thread. You might also consider posting that question to Social.msdn.microsoft, the DBPro forum.

    I am aware of another team that's trying to solve the problem of managing databases through ERStudio. They're having a very hard time of it too. I just think it's a poor choice of tool for managing deployments. Embarcadero tools, damned fine tools, are built to support multiple environments, but they don't support any single environment, such as SQL Server, terribly well.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning