New Upgrade Assistant for SQL Server 2014 (UAFS)
We jointly developed with Microsoft the Upgrade Assistant for SQL Server (UAFS) 2014. This free tool, which is licensed from Microsoft, helps automate application compatibility testing to detect potential issues that may impact a database upgrade from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008 or SQL 2008 to SQL 2012, or SQL 2012 to 2014. This tool is backward compatible back to SQL 2008.
UAFS verifies how queries from a SQL Server application will function when the database is upgraded. The SQL 2014, SQL 2012, SQL 2008 and SQL 2005 versions are available on our tools download page.
If you have questions or require assistance with UAFS please post your questions at Microsoft Forums.
To ensure Scalability Experts and Microsoft continue to provide the best upgrade assistance possible, please provide feedback on your experience with UAFS. You may ask questions about this tool or upgrades in general at http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
SE SQL Server Discovery Tool (SSDT)
When preparing for consolidations or upgrades with SQL Server, it is imperative to know and list all SQL Server instances within your data environment. Many customers have more SQL Servers than they know about. Obviously without an accurate and complete list, your consolidation or upgrade will lack complete data.
We developed SSDT, a utility that scans your network domain utilizing SMO, SMI and registry settings, and then automatically prepares a list of all SQL Server instances in an Excel format.
The SSDT system and user requirements are straightforward so preparing for approaching upgrades and consolidations is simple and quick. The SSDT process is easy to follow yet provides complete SQL Server data information. Click here to download the SSDT.
Sample Output Data