SQL Server 2005 Vs Oracle

Apr 6, 2006

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


View 42 Replies


Native Oracle SQL -&&> SQL Server 2005 CE .sdf File -&&> Using Visual Studio 2005?

May 23, 2007

I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as:

select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table

There's also a CASE statement in there with some other data transformations.

Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005.

For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work.

I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!!

Can anyone help?



View 6 Replies View Related

Oracle And SQL Server 2005

Oct 20, 2007

I have more than 8 GB Data in oracle and Everyday we have to check some data in oracle but it takes times due to lot of data. So what i was looking that data that we need can import in SQL Server database and do checking purpose. But I was looking some command that connect to oracle brings its data and import in SQL Server. For that we will fire SQL statement to oracle through asp.net and  insert into SQL Server I will fire differencial data insert covery only. is there any way or idea to do that please advice me.

View 3 Replies View Related

Oracle .dmp To SQL Server 2005

Aug 28, 2007

I am trying to import an Oracle .dmp database into SQL Server 2005, what would you suggest as the fastest and easiest way to do this? DTS/SSIS doesn't have an instant solution and the script I tried to use gave me an error...

Msg 3241, Level 16, State 0, Line 1

The media family on device '<DATABASE>' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

I would like a GUI based way to do this if at all possible. Thanks

View 8 Replies View Related

DTS From Oracle To SQL Server 2005

Mar 13, 2008

Hello guys,

I'm relatively new to DTS and I was trying to import data from the oracle database to SQL server database based on some parameter from the destination table.
i.e select * from SourceTable where SourceTable.Column1 > (select max(Column1) from DestinationTable)
This tries to search DestinationTable from the source database(Oracle)
How shoud I go to solve this problem?
Any Hint is greatly appreciated....

View 1 Replies View Related

SQL Server 2005 64-bit &&amp; Oracle

Feb 21, 2008

OK new Windows 2003 Enterprise 64-bit with MS SQL Server 2005 64-bit.. Now I am migrating the DTS packages from our olld Windows 2000 Standard with MS SQL 2000 (all 32-bit). I am not moving the packages to SSIS yet just want to move the legacy DTS jobs over... However whenever I try and connect to the Oracle DB I got ORA-12154: TNS:could not resolve the connect identifier specified.

I have the Oracle 10g 32-bit & Oracle 10g 64-bit clients installed and I can run SQL+Plus and do everything just fine. It is just in MS SQL 2005 I can not. Even in SSIS I get the ORA-12154 error. I can create an ODBC and test it and it works just fine... Has anyone here ever fixed this? Some say it is b/c of the ('s around x86 in program files and I have done their suggestion in making a ProgramFilesx86 directory and copy the visual stupid & sql directories there... still nothing. I have one of my DBA's searching Oracle for any patches but thought I would ask and see.


Billy S.

View 3 Replies View Related

SQL Server 2005 Versus Oracle

Jun 18, 2007

If there is someone who is intimate with both sqlserver and oracle tell me the main differences between the two?

what features are not available in either one? is one better for certain situations over others?

View 5 Replies View Related

Tutorial For DTS From Oracle To SQL Server 2005

Jan 9, 2008

I want the tutorial for developing Integration Service for copying the database from Oracle 9i to SQL Server 2005.

If anybody knows then pls give me the steps..

Thanx in advance.

View 1 Replies View Related

Tuning On Oracle 10g And SQL Server 2005

May 4, 2006

Does anyone have some more detailed information about how Oracle and MSimplement / allow Tuning on Oracle 10g and SQL Server 2005 and thedifferences between them?Which of them, In a deep comparison about it, allow better tuning andwhy.Regards,Marcio Evangelista

View 3 Replies View Related

Replication From Oracle 10g R2 To SQL Server 2005 SP2

Oct 6, 2007

Hello All,
I created all the role and logins as described in oracleadmin.sql file and were able to query Oracle tables.
But when I try to crate publisher on Oracle server from sqL server I get the following error:
TITLE: Distributor Properties

An error occurred applying the changes to the Distributor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.3186.00&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476


SQL Server could not enable 'oracle_dev' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Failed to execute the HREPL.INITPUBLISHER request to Oracle Publisher 'ORACLE_DEV'. Verify that the Oracle package code exists on the Publisher, and that the replication administrative user account has sufficient permissions.
Changed database context to 'master'.
OLE DB provider "MSDAORA" for linked server "ORACLE_DEV" returned message "One or more errors occurred during processing of command.".
OLE DB provider "MSDAORA" for linked server "ORACLE_DEV" returned message "ORA-06550: line 1, column 8:
PLS-00201: identifier 'HREPL.INITPUBLISHER' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Error: 7215, Sev: 17, State: 1, Msg: Could not execute statement on remote server 'ORACLE_DEV'. (Microsoft SQL Server, Error: 21651)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3186&EvtSrc=MSSQLServer&EvtID=21651&LinkId=20476

I searched the web and could not find any related info, where is this package can I run it manually?
Any help appreciated.

View 6 Replies View Related

Equivalence Of Oracle's LEAST In SQL Server 2005

Nov 20, 2006

Greetings, i just want to know what would be the equivalent sentence of


in SQL Server 2005. I suposse that i could just use MIN function in this case?

Thank you in advance,


View 7 Replies View Related

Oracle's TO_CHAR, What In SQL Server 2005?

Nov 22, 2006


In oracle i use the following sentence TO_CHAR(Table1.DateIn, ,'mm/yyyy') within a query. I need how to replace this for using it in SQL Server. I tried to use the SQL Server CONVERT function but nothing work. Could you help me?

Thank you in advance,


View 3 Replies View Related

Publishing From Oracle To Sql Server 2005

Sep 13, 2005

HI guys,

View 3 Replies View Related

Sql Server 2005 Sp2 And Oracle Access

Nov 21, 2006

When I try to create a model in Report Builder based on a connection to Oracle 10g database I get the following error.


Is this a bug in the CTP version or am I missing something?

View 19 Replies View Related

Migrating From Oracle To SQL Server 2005

May 30, 2006

I am migrating a database from Oracle to SQL Server 2005. I have a problem when migrating code from PL-SQL (oracle labguage) to T-SQL (sql server language). My problem is: there is pseudo-column in oracle called level that return the level from a register in a tree view of a select (a parent-child relationship). I would want to know how to translate that level column to T-SQL. Thanks!

View 3 Replies View Related

What Are The Differences Between MS SQL Server 2005 &&amp; Oracle 9i ?

Aug 5, 2006

Hi guyz,
I have basic knowledge of Sql Server 2005 and now i wanna move ahead in Oracle 9i !
So, i have 2 questions here -

a)Whats the Difference between Sql Server 2005 and Oracle 9 i ?

Note: Please keep the discussion general so that student like me can understand. I have never seen Oracle but the industry requirements suggest that Oracle is way better than than SQL Server 2005. But thats what i think

b)I am Running Windows XP SP 2 and i would like to practise Oracle 9i. So, Where i can download it for free ? I know i have checked there website but they don't mention the difference between each version. Oracle does't market their products as well as Microsoft.

Please , I am Student .. so i request you to make the discussion general .
Thank you for your time.

View 7 Replies View Related

Oracle/Unix Environments --&&> SQL Server 2005/Windows 2003 Server

May 8, 2007

I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup.

Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB.

Have these initial questions..
Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc

Any Input / Direction is appreciated...

View 4 Replies View Related

Importing Data From Oracle 10g To Sql Server 2005 Using Linked Server

Jul 30, 2007


I am using Windows 2003 server and Sqlserver 2005 by the use of Linked server , I made a connection to Oracle 10g after that I am importing records from Oracle to sqlserver 2005. When I made tnsnames.ora in sql machine , it worked fine but when i am using tnsnames file from oracle server then i fiired importing procedure it returns below maintain error :

OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Unspecified error".

OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Oracle error occurred, but error message could not be retrieved from Oracle.".

Msg 7311, Level 16, State 2, Line 1

Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS". The provider supports the interface, but returns a failure code when it is used.

Please let me know.


View 15 Replies View Related


Aug 13, 2006

In ORACLE 9i, I created the table test that show the tree structure of an organizaion with the following SQL statement:


And select the data using the following SQL Statement:

The result is:
0 2461
2461 2463
2461 2462
2462 2465
2462 2466
2463 2469
2463 2470

To show the subnodes of the root node 2461, the following SQL Statement is used:


the results:

0 2461
2461 2463
2463 2469
2463 2470
2461 2462
2462 2465
2462 2466

I have created the table test with the same structure and the same data in SQL Server 2005. To show the subnodes of the root node 2461, the following SQL Statement is used:






The results are shown again in Oracle 9i and SQL Server 2005 as follwos:

Oracle 9i SQL Server 2005

0 2461 0 2461
2461 2463 2461 2463
2463 2469 2461 2462
2463 2470 2462 2465
2461 2462 2462 2466
2462 2465 2463 2469
2462 2466 2463 2470

How can I get the result with the same sequence in SQL Server 2005?


View 11 Replies View Related

Sql Server 2005 Versus Oracle 10g Certification

Mar 21, 2008

hi guys,
I am joining IT industry in august,my main intrest is in database(readed some stuff of warehousing oracle 9i and sql).
However to move my career in that direction i need certification.
So here is the point,should i get MCTS(in sql server 2005) or OCP(oracle associate 10g).
My main goal is to become DBA. which of the above is more benificial.
I mean more oppurtunites.

please reply.

View 4 Replies View Related

Extracting The Oracle Data Into SQL Server 2005.

Apr 28, 2008

Hi All,

We are extracting the data from ORACLE databse into SQL Server 2005 database. Both are hosted on different servers.

For this we have created linked server on SQL Server and we using the OPENQUERY to extract the data. Its taking too much time to extract the data.

Is there any other alternate thing for OPENQUERY clause.

Please help me on this.

Thanks in advance.


View 3 Replies View Related

Oracle Sequence/Link 2 MS SQL SERVER 2005

Nov 30, 2006

hi,1. is there a statement in ms sql, what creates a sequence? cant findanything in web :-(-oracle: CREATE SEQUENCE XYZ INCREMENT BY 1 START WITH 1 NOCYCLECACHE 20;-ms sql: ???2. hwo do i create a link to another ms-sql databasethx a lot need help, urgend :-)

View 14 Replies View Related

Accessing Oracle Data In Sql Server 2005

Feb 20, 2008

I need some help regarding the data access.
I needs to access some data from tables which are in oracle and load it into sql server tables.
Please let me know the process for this.

Thanks in advance.

View 2 Replies View Related

Oracle TimesTen Vs SQL Server 2005/2008

Nov 15, 2007

For a high-performance and time/mission-critical application in the Telecom industry we have a project where uber-low latency is crucial. Oracle has acquired TimesTen in 2005 and I was wondering if there are performance comparisons between SQL Server 2005/2008, Oracle and other DBMS vendors?

I would also like to know from you guys what your experiences are with using SQL Server for time-critical applications.

What can we do to get the maximum out of SQL Server 2005/2008 if the hardware it will run on is not an issue. For example a 16-core machine ...

Any feedback is appreciated.

View 3 Replies View Related

Oracle 10g R2 To Sql Server 2005 - Publisher Set Up Error

Jun 7, 2007

I am receiving the following error message when trying to create a new Oracle Publisher.

Msg 21684, Level 16, State 1, Procedure sp_ORACheckAdminPrivileges, Line 136

The permissions associated with the administrator login for Oracle publisher 'NT02' are not sufficient.

We have added the following permissions manually (not through a role) in Oracle:


And we have also tried the Program FilesMicrosoft SQL Server<InstanceName>MSSQLInstalloracleadmin.sql script.

In both cases we are receiving the error message above. The only way we seem to be able to get around the error is to grant the DBA role to the replication schema user, which doesn't seem right.

Has anybody run into this problem before? How did you get around the problem?

Also is there a way to view sp_ORACheckAdminPrivileges because it's doesn't seem to be viewable anywhere in the database? This would at least let us know what it's looking for from an Oracle standpoint.

Help would be appreciated.


View 5 Replies View Related

Need To Copy All Oracle Tables To SQL Server 2005

Jan 31, 2007

I am racking my brain on this one. I am migrating Oracle data to SQL Server and would like an SSIS package that will copy the oracle data from every table to SQL server. I already have the schema set up in SQL and a straight copy of a specified table works fine between the OLEDB source and OLEDB destination. However, when I set up a loop which sets a global variable for the table names, which are identical on both dbs, and try to set the OLEDB Source and Destination OpenRowsetVariable to the global variable, the process fails with these errors with all validation turned off:

[OLE DB Source [18]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

[OLE DB Source [18]] Error: Column "ID" cannot be found at the datasource.

[DTS.Pipeline] Error: component "OLE DB Source" (18) failed the pre-execute phase and returned error code 0xC0202005.

To sum up, I want to set the tables dynamically and have them infer the mappings. The names of the columns are already the exact same on each schema, and the data types are mapped accordingly. I have already verified that the names of the tables have been formatted correctly for each database. If I can't do it this way then how?

View 14 Replies View Related

Move Oracle Data To SQL Server 2005

Nov 19, 2007


When i try to use the Microsoft OLE-DB Drive for oracle in import/Export Wizard, it gives me message that Oracle networking driver is missing. Contact Oracle for this information.

Any idea to further move on this. I am wondering, why SQL Server 2005 does not have that driver.


View 1 Replies View Related

Data Migration From Oracle 10g To SQL Server 2005

Dec 14, 2007


I'm new to SSIS.

I want to migrate data from Oracle Database to SQL Server 2005 by using SSIS Package. Client wants to migrate just data not schema. Schema is already there for SQL Server, generated through script.

I tried to migrate the data by using import-export wizard in SSIS. But, its asking for creating new tables when migrating data.

I want to migrate data in existing tables, without dropping already existed tables or creating new tables.

any suggestions ?



View 7 Replies View Related

How To Integrate Oracle With SQL Server 2005 By Link Server?

Jul 30, 2006

please tell me the best way?



View 2 Replies View Related

Can't Connect To Oracle Dbase With SQL Server 2005 Express

Dec 16, 2005

Hi,I'm attempting to connect to an Oracle database using SQL Server 2005Express (OS is Windows XP Professional) and having absolutely no luck.Here is the information SQL Plusgives me about the database when I log in -Connected to:Oracle9i Enterprise Edition Release - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release - ProductionAs you can see I have no problem connecting with the Oracle specifictools (SQL PLUS and PL/SQL Developer).I've tried creating a linked server with both the Microsoft providedOLE DB provider and the Oracle provider. With the Microsoft Provider Iget the following error when attempting a query in the query editwindow.OLE DB provider "MSDAORA" for linked server "ORACLE" returned message"Oracle client and networking components were not found. Thesecomponents are supplied by Oracle Corporation and are part of theOracle Version 7.3.3 or later client software installation.Provider is unable to function until these components are installed.".Msg 7303, Level 16, State 1, Line 2Cannot initialize the data source object of OLE DB provider "MSDAORA"for linked server "ORACLE".When I try connecting withe Oracle provider I get the following -OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2"returned message "ORA-01017: invalid username/password; logon denied".Msg 7303, Level 16, State 1, Line 2Cannot initialize the data source object of OLE DB provider"OraOLEDB.Oracle" for linked server "ORACLETEST2".I've set the password up as a local to remote login mapping using thesecurity page of the Linked Server property dialog. The username /password are definitely correct -- I used them to log in using SQL PLUSand PL/SQL Developer. I'm using an Oracle 9 client.PLEASE HELP !!!!!Thanks,Signed Frustrated

View 8 Replies View Related

Oracle 9i -&&> SQL Server 2005: Initialization Of Table Failes

Jun 8, 2006

Hi there,

I'm trying to initialize a subscription for a transactional replication between Oracle9i and MS SQL Server 2005.

The snapshot agent runs succesfully, but I get an error when the distribution agent runs to apply the snapshots at the subscriber. I've pastet the job history from the Log File Viewer below.

2006-06-08 09:27:25.516 Applied script 'ADDRESS_8.sch'
2006-06-08 09:27:25.516 Applied script 'ADDRESS_8.idx'
2006-06-08 09:27:25.516 Bulk copying data into table 'ADDRESS'
2006-06-08 09:27:25.641 Agent message code 20037. The process could not bulk copy into table '"ADDRESS"'.
2006-06-08 09:27:25.704 Category:NULL
Source: Microsoft SQL Native Client
Message: Data conversion failed
2006-06-08 09:27:25.704 Category:NULL

Every column contaning null-values at the table in Oracle9i is allowing null-values at the destination table in the SQL Server.

I'm pretty lost here - does anyone know how to solve this problem?

Best regards,

JB Plum

View 6 Replies View Related

Oracle 9i -&&> SQL Server 2005: Violation Of PRIMARY KEY Constraint

Jun 24, 2006

Hi there,

When the distribution agent runs trying to apply the snapshot at the subscriber I get the following error message

2006-06-24 12:41:59.216 Category:NULL
Source: Microsoft SQL Native Client
Message: Batch send failed
2006-06-24 12:41:59.216 Category:NULL
Source: Microsoft SQL Native Client
Number: 2627
Message: Violation of PRIMARY KEY constraint 'MSHREPL_1_PK'. Cannot insert duplicate key in object 'dbo.ITEMTRANSLATION'.
2006-06-24 12:41:59.216 Category:NULL
Number: 20253

What could possibly cause this error? And how can I possibly fix it?

Best regards,


View 7 Replies View Related

2005 Reporting Srv Cannot Connect To Oracle Datasource On Web Server

Nov 18, 2006

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

View 4 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved