Porting from oracle to SQL Server - Microsoft SQL Server

golu

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

Jul 23 '05 #1

Subscribe Reply

2007

John Bell

Hi

This may give you a start!
http://www.microsoft.com/resources/d...rt2/c0761.mspx
http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

John

"golu" <sa***********@ lgsoftindia.com > wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

Jul 23 '05 #2

DA Morgan

golu wrote:

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

Oracle's multiversioning does not exist in SQL Server.
Oracle's sequences do not exist in SQL Server.
Oracle's unlimited row level locks does not exist in SQL Server.
Many of Oracle's trigger types do not exist.
Same holds for partitions, IOTs, GTTs, and numerous other object types.

In short ... I'd suggest you rewrite ... not port.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

Jul 23 '05 #3

JinJJa

It is best to use SQL DTS to port Oracle to SQL. It is, however, a very tricky
process and I recommend you do not proceed without an extensive research (sorry
but the steps are too many to mention here).

Oracle's sequences do not exist in SQL Server.
SQL has identity columns, which, of course, are different from Oracle's
sequences. But they are highly similar.

Oracle's unlimited row level locks does not exist in SQL Server.

I hear this a lot from Oracle folks. But SQL had row level locking since SQL 7.
And having an "unlimited row level locking" isn't even adviced or efficient in
most cases.

Joe
MCDBA, MCSD, OCP

Jul 23 '05 #4

database.replication

DTS would be convinient tool if tables are not very big.

If size of Oracle database and batch window are concerning, you may
want to check out FastReader : http://www.wisdomforce.com for
integrating SQL and Oracle on a continuing basis
golu wrote:

Has any body done the porting from oracle to sql server, what were the issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project TIA
Golu

Jul 23 '05 #5

Similar topics

2624

Porting database from Oracle7.0 to Oracle8i

by: Vijay Singh | last post by:

Hi Does anybody know if Oracle provides any tool or script for porting database from Oracle7.0 to Oracle8.0. I know one can do it using Oracle*Export, but I am looking for a tool. Vijay

Oracle Database

4038

connectivity - integration Oracle - SQL server

by: Ton | last post by:

I have a question about connectivity between different databases. Oracle, DB2400 and SQL_server. It is easy to integrate application products that are running on different DB platforms? What products can be used to achieve this? Our consultant is mentioning .NET but then we have to run everything on SQL server. Currently we are running on Oracle but our third party generic applications are first developed for SQL server and later...

Oracle Database

24284

Linked Server (Oracle 9i)

by: David Gray | last post by:

Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools

Oracle Database

2838

Trigger porting problem

by: gustavo_randich | last post by:

Hi :-) I'm porting a project from Oracle to DB2 and now I'm trying to avoid error SQL0746N in a trigger which reads the same table in which the trigger is defined. Below is Oracle's workaround for this problem (Oracle raises a similar error when trying to do this). It uses a package to temporarily store affected rows in a BEFORE trigger for later processing in an AFTER trigger. Is there a functionality in DB2 similar to Oracle's...

DB2 Database

4239

Convert MS Access DB (FE&BE) to Oracle

by: egoldthwait | last post by:

I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with this. Also - the citrix folks do not want us to keep the FE in Access as the queries and other activities consume a lot of power. The users will be in 3 different offices across the globe all accessing the 1 Oracle DB in Citrix. Does anyone have...

Microsoft Access / VBA

6755

SQL Server 2005 vs Oracle

by: Paul | last post by:

Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse Management System which wil manage our very large inventory. Anyway comments suggestions welcome Thanks Paul

Microsoft SQL Server

1474

trouble porting a trivially simple function - with declared variables

by: Ted | last post by:

Here is one such function: CREATE FUNCTION my_max_market_date () RETURNS datetime BEGIN DECLARE @mmmd AS datetime; SELECT max(h_market_date) INTO @mmmd FROM holdings_tmp; RETURN @mmmd; END One change I had to make, relative to what I had working in MySQL, was

Microsoft SQL Server

1969

Oracle Fianacials And Oracle Projects Upgrade

by: anneeny | last post by:

Hi there... My company has implemented Oracle Financials and Project applications in 1999 as a part of Y2K project. Oracle 11.0.3 Applications are implemented in 3-tier configuration as per the details given below:- Database Tier: The database tier consists of Intel Server running Windows 2000. This server is dedicated to host ORACLE FINANCIALS DATABASES (8i Enterprise Edition with 8.1.7.4.6 patch set) both for the production and test...

Oracle Database

4643

Not able to open test.fmx in oracle application server 10gR2

by: sathyguy | last post by:

when i type the below in my RHEL AS 4's Firefox 1.5 http://appsworld.ncc.com:7777/forms/...&form=test.fmx iam getting the below error... The requested URL /forms/frmservlet was not found on this server. formsweb.cfg contents...... baseHTML=/u01/app/oracle/OraHome_1/forms/server/base.htm

Oracle Database

8822

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9528

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9359

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9236

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8235

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6792

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6072

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4592

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3298

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp