.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Oracle Migration assitance to remove SYSDB dependency

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

Recently for a customer we migrated Oracle database to SQL Server 2008 using SSMA tool (SQL Server Migration Assistance for Oracle).The SSMA tool also creates a SYSDB database on the SQL Server instance which contains the replica of Oracle system function that do not exists in SQL Server.


Now the scenario is following statements cannot be executed inside the user defined function of SQL Server:

1) Raising errors or exceptions handling

2) Print statements

3) DML operations  like UPDATE, INSERT, DELETE that modify tables, except for local table variables

4) A call of a stored procedure


View Complete Post

More Related Resource Links

How to remove the Controller postfix dependency in naming controllers?

In the  Controllers directory, naming every controller with "Controller" prefix seems plain stupid. Is there a way to remove this dependency?

Appreciate your comments on Database migration from Oracle to SQL Server ...


Appreciate your comments on Database migration from Oracle to SQL Server ...

From my perspective, there are two major known issues that would cause major

resource consumption for porting My-App from Oracle to Microsoft SQL Server. First,

the Perl code within My-App reads the Oracle object meta-data for defining it's

internal objects and data types. SD would be the best group to identify the effort

to replace this dynamic functionality. The second issue is the coding required

to replace Oracle's built-in functionality to work with data hierarchies / tree

structures / parent-child relationships.

The My-App Data Model is heavily based on parent-child relationships through out

numerous tables; every item has a parent, every person has a manager, every team

may or may not be nested, etc. Oracle has native SQL clause, connect_by, to query

these structures. Oracle also provides pseudo columns for the connect_by meta data,

such as levels, path, isleaf, cycle options, etc. The connect_by functionality with

Microsoft SQL Server (see Reference below) is done natively with a "with" clause or

via custom procedures. SQL Server does not provide any pseudo columns functionality.

Also, SQL Server does not support any analytic and aggregate func

datatype tranformation issue in oracle to sql 2008 migration using SSIS


Hello friends

I am doing oracle to SQL2008 R2 migration and i want to use SSIS.

Oracle has mainly three datatypes DATE, VARCHAR2 and number. 

I tried without using the transformation it worked but the datatypes like date did not changed to datetime in sql server, even the number datatype remain same.

secondly while doing very first time i got very weired name of the table on sql side. 

Instead of going to dbo schema it shows the name like tom\myname.A_RETURNS.

So how can i resolve both the datatype and naming issue?

Thanks in advance..


Error while oracle to sql migration with SSIS


Hello frnds 

i am getting these errors in the SSIS package which is importing  data from oracle to SQL SERVER.

1)[OLE DB Destination [22]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80004005  Description: "Invalid date format".

2)[OLE DB Destination [22]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Destination Input" (35)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (35)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

3)[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "OLE DB Destination" (22) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (35). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. &n

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Dependency Properties

When you begin to develop appliations with WPF, you will soon stumble across DependencyProperties. They look quite similar to normal .NET properties, but the concept behind is much more complex and powerful

Remove #Region from whole web site


Hi All,

I need to deliver source code to client and my boss need to remove all the comments and #region sections from the whole web site source code.

So is there any functionality available in visual studio 2010 or may be in an other 3rd party tool available to do so, which can remove all the #region from all over the source code ?

Otherwise my developers has to do donkey work.... :(( and I don't wish it. 

Any help or tips/tricks would be appreciated.


Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

Web deployment project - web.config section replacement does not add remove tag


I have a web application that is actually installed as a component of a third party site.  In some configurations, I need to remove certain connection strings and re-add them.  I'm replacing this web.config section with a xml file that includes the following:

      <remove name="MyOverridenConnection"/>
      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

For some reason the remove tag is left out during the substitution and I end up with the following in the installed config:

      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

Is there any way to issue removes in replaced sec

Migration from ASP.NET 3.5 to 4.0


So, I just recently started to migrate my website from 3.5 to 4.0.   I am running in a bunch of issues but mainly 2 so far that have me stumped.

1. I have a custom URL rewrite module that I use, and it seems like it's being ignored to some extent.  It works fine if I run it through Visual Studio 2010 debugger, so I have no idea why it's not being fired. 

2. In some of my pages, I reference a BasePage class instead of System.Web.UI.Page.  The ones that reference this BasePage class works fine, but when I use System.Web.UI.Page, I get : Object reference not set to an instance of an object when I try to create an object.

Any ideas? 

Migration to .Net 2 and includes



I'm currently having a problem with one of our old .Net 1.1 applications. For generating the user interface, a lot of incude statements were used.

<!--#include file="includes/header.aspx"-->

In these includes, the variables from the parent files are used.

Now I have to use at least .Net 2 and Visual Studio 2010. The problem is that VS tries to compile these include files, which of course failes.

Is there any way to restore the old behavior again?



Remove characters in a string


i have a string like this   sravani/, asdfff/, lsdsf/
i want to remove last character '/'  in the above string...
which function can i use?

pls help me....

Inside Microsoft patterns & practices: Dependency Injection in Libraries


This article discusses how to write a library or framework that uses the Dependency Injection pattern and how the change in focus affects the usage of the pattern.

Chris Tavares

MSDN Magazine November 2009

Foundations: Dependency Properties And Notifications


Windows Presentation Foundation dependency properties don't always play well with others. Learn how you can compensate for their lack of notification events.

Charles Petzold

MSDN Magazine September 2008

{ End Bracket }: Dependency Management


Dependency management, in which one group provides a software component to be utilized by others, can really benefit from some structure and collaborative efforts.

Eric N. Bush

MSDN Magazine August 2007

Design Patterns: Dependency Injection


Today there is a greater focus than ever on reusing existing components and wiring together disparate components to form a cohesive architecture. But this wiring can quickly become a daunting task because as application size and complexity increase, so do dependencies.

Griffin Caprio

MSDN Magazine September 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend