Lista podstawowych usług IT + Migracja Orac->MS

Oto lista podstawowych (core) usług świadczonych przez dział IT wg. firmy Microsoft (wg. Windows Server System Reference Architecture (WSSRA)):

• Zarzadzanie urzadzeniami:

1. siecia
2. pamiecia
3. komputerami i perferia
   

• Zarzadzanie usługami (serwisami):

1. instlacja
2. sieć
3. zapora
4. AD
5. udostępnianie plików i drukarek
6. aplikacje internetowe
7. usługi udostępniania danych
8. zarzadzanie infrastruktura
9. tworzenie kopii zapasowych i odzyskiwanie danych
10. certyfikaty i klucze
11. zdalny dostęp
12. warstwa middleware
13. komunikacja korporacyjna

Ciekawy dodatek: Migracja Oracle->MS SQL Server jest pod tym adresem
Oprogramowanie do migracji (w fazie beta) jest tu.

Skrót:

Technical Subjects Covered in This Guide

The following technical topics and subject areas are included in this guide:

	Migration of a typical Oracle database, including objects (such as tables, indexes, views, triggers, and stored procedures) and the contents of the objects to SQL Server.
	Methods and procedures that focus on taking advantage of existing applications on UNIX platforms by communicating with SQL Server on Windows.
	Migration of applications and APIs to work under Microsoft Win32®, Microsoft Windows Services for UNIX, and Microsoft .NET.
	Application and API interoperability with SQL Server, including: • Java 2 Enterprise Edition (J2EE) and Java Database Connectivity (JDBC) • Open Database Connectivity (ODBC) • Perl, including the DBI and DBD modules • PHP • Python • Pro*C • Oracle Forms
•	Microsoft offers the SQL Server Migration Assistant toolset for the migration of Oracle databases to SQL Server, including: • Migration Analyzer—analyzes the source Oracle databases and produces vital statistics on the size and complexity of the migration. • Schema and Data Migrator—migrates the Oracle schemas and moves the data into the new SQL Server objects. • SQL Converter—converts code found in Oracle objects to their T-SQL equivalents. • Migration Tester—automatically tests the converted code.

These tools can be downloaded from http://www.microsoft.com/sql/migration/. The tools are in beta as of the date of publication for this solution. Version 1 of the tools is slated for release in June 2005 and will be available for download at the same location.

Technical Subjects That Are Not Covered in This Guide

The following technical topics and subject areas are not included in this guide:

Oracle versions earlier than 8i and Oracle 10
	SQL Server versions earlier than SQL Server 2000
	Design of hardware architecture
	Modeling and design of databases
	Procedures for database administration functions, such as capacity planning, backup and recovery, performance tuning, and monitoring
	Aspects of the database that could be rendered inapplicable in the new environment, such as archived data and backups
	Features available in Oracle that do not have corresponding features in SQL Server, such as spatial data, XML DB, flashback query, SQLJ, and XSQL
	Installation of application clients, or client connectivity to the application server or database
	Migration of the operating system to Microsoft Windows Server 2003
	Support for Open Management Group (OMG), an open-source, java-based standard for metadata
	Data extraction from enterprise resource planning (ERP) systems

While these technical subjects are not explicitly discussed in this guide, information about many of them is available from Microsoft. Where appropriate throughout this guide, links to more information are provided.