Blogger :
MSDN Blogs
All posts :
All posts by MSDN Blogs
Category :
Other ERP
Blogged date : 2006 Feb 08
The word is getting out - SQL Server 2005 just flat out rocks in regards to performance and scalalbility. Did you know SQL Server includes:
- Reporting Services: a reporting engine that outputs highly complex, graphics-laden reports in HTML, Excel, PDF, CSV, and XML formats?
- Development is easy: the environment is built into VS.NET
- Reporting against OLAP cubes is simple - no more need to know MDX! Just drag and drop.
- Integration Services: a full fledged ETL tool for loading and transforming data from multiple data sources, including FTP, web services, and .NET.
- Analysis Services: An OLAP engine for creating and querying data cubes.
- Notification Services: Create alerts and notifications based on data events.
...and of course, the fast database engine - all rolled into the same license!
Several ISV partners have inquired about migrating away from Oracle to SQL Server 2005. Microsoft offers the SQL Server Migration Assistant (SSMA) as a free download that includes an entire toolkit for database migration. Here are the links to get you started:
Migrate to SQL Server Homepage, Download site for SSMA, SSMA FAQ

More info on SSMA:
SQL Server Migration Assistant (SSMA) defines and automates all of the major steps in the database migration process. SSMA provides comprehensive assessment reports, one-click conversion of all schema and data, one-click conversion of almost all database-resident business logic, and automated testing of the converted code. All of these capabilities are made available from within a single migration IDE.
With a single click, SSMA converts all database objects including stored procedures, functions, triggers, views, packaged procedures, packaged functions, and sequences. SSMA also provides contextsensitive warnings and output messages. The conversion engine encapsulates Microsoft's patentpending technology that represents one of the most complete PL/SQL to Transact-SQL conversion capabilities available.