This post is about new version releases of SQL Server Migration Assistant (SSMA); it’s a tool that assists clients in migrate their oracle databases to SQL server 2014. Aegis Software team of BI developers from India is sharing this information with entire community and users of Microsoft BI (Business Intelligence). SQL Server 2014, a BI tool that was released this year and it offers feature rich performance to the BI developers such as
- In-memory OLTP for fast transactions
- In-memory Columnstore for fast query performance
- Cloud back up from SQL server management studio
- Use of Azure as a disaster recovery site
With availability of SQL Server Migration Assistant version 6.0, BI developers can now migrate their oracle databases to SQL server without hassle. SSMA is an automatic system that meets all migration aspects comprising schema, migration assessment analysis, SQL statement conversion, Migration testing and data migration for cost reduction and risk reduction of database migration project. Besides this functionality, this latest version also brings extra features for Oracle databases, like- automatic migration of Oracle tables into SQL Server 2014 in-memory tables, enhanced performance in report generation and database migration, and capability to migrate 10,000 oracle objects at a time.

This BI tool is designed for migrating Oracle 9i or later version to SQL server editions – 2005, 2008, 2012, 2014, and SQL server 2008 R2. Aegis software Microsoft Power BI developer from India are here to provide business intelligence solutions.
For technical assistance, you can Contact Us at - info@aegissoftwares.com