The best what I liked in ApexSQL is fast database creating, tables' autofill.
1.Little bit complex to learn for beginners 2.Performance issues with large databases.
It's an essential tool to write t-sql with efficiency and simplicity. My compagnie is using it sine 2010 . it is part of our best pratice internaly
When refactoring cross database dependencies are hard to get right. As an example a secondary database has a synonym to table in the primary database. Then when a column in table in primary database is renamed you really want the SPs etc in the secondary...
The best what I liked in ApexSQL is fast database creating, tables' autofill.
It's an essential tool to write t-sql with efficiency and simplicity. My compagnie is using it sine 2010 . it is part of our best pratice internaly
1.Little bit complex to learn for beginners 2.Performance issues with large databases.
When refactoring cross database dependencies are hard to get right. As an example a secondary database has a synonym to table in the primary database. Then when a column in table in primary database is renamed you really want the SPs etc in the secondary...