Non-SQL Server Publishers

Publishing data from non-SQL Server sources allows you to consolidate data in Microsoft SQL Server. SQL Server can subscribe to snapshot or transactional data published from an Oracle database. For more information about publishing from Oracle, see Oracle Publishing Overview.

Publishing from non-SQL Server databases is ideal for the following scenarios:

Scenario	Description
Microsoft .NET Framework application deployments	Develop with Microsoft Visual Studio and SQL Server while operating on data replicated from a non-SQL Server database.
Data warehousing staging servers	Keep SQL Server staging databases synchronized with a non-SQL Server database.
Migration to SQL Server	Test your application in real time against SQL Server while replicating the source system's changes. Switch to SQL Server when satisfied with the migration.

See Also

Concepts

Heterogeneous Database Replication