Browse by Tags

SQL Server Migration Assistant - what are the conversion rules between Oracle and SQL Server during the migration?

Published 9 September 8 2:46 AM | SSQA.net

This was the big question posed by the users when a migration project is initiated at one of client's place. SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other...

Filed under: sql server, data, object, oracle, stored procedure, tables, ssma, migration, views, rules

How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?

Published 28 August 8 3:1 AM | SSQA.net

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...

Filed under: sql server, oracle, transactions, ssma, dtc, data-migration, autonomous, mode

SQL Server Migration Assistant tools from other data sources - 2005 & 2008 versions

Published 4 August 8 7:58 AM | SSQA.net

From the blog of Technical Rollup mail that we receive from Microsoft here is the list of SQL Server Migration Assistant tools available from Microsoft to migrate/upgrade data from other data sources such as Access, Sybase & Oracle. _________________________________________________________________________________________________________________________...

Filed under: sql server, version, access, oracle, data sources, sysbase, migration assistant

FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

Published 19 August 7 4:40 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle...

Filed under: sql server, replication, kba, service pack2, oracle, linked, publisher

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked

Unique blog post I have ever seen that covers all RDBMS platforms

Published 15 June 7 7:51 AM | SSQA.net

I was just browsing through the blogs on WordPress as it is one of my favourite blog sites, I came across this VanitiesForDBA post which is most amusing that the author 'coskan' has covered all major players in RDBMS technologies (MSSQL, Oracle...

Filed under: sql server, mysql, oracle, sybase, db2