Oracle To Sql2k5 Migration

Oct 9, 2007

Hi

I am a Oracle DBA who is going to embark upon a
oppurtunity to migrate Oracle to sqlserver.

Can somebody give me tips for
Learning sqlserver2k5 for a Oracle DBA Books
Or Beginner DBA/Development Books for sql2k5

How good is the migration assistant from m$$ for
migrating from oracle to sql2k5

Does it migrate data as well as procedural code ?

Do you anything for me to watch out for best parctices
migration guides

You opinion would be higly appreciated


regards
db2hrishy

View 2 Replies


ADVERTISEMENT

Where DTS In SQL 2005; Oracle To SQL2k5??

Nov 2, 2006

I need tyo move tables from Oracle 9.2 or 10.2 version to SQL server 2005.Can any one give me some good hints, scripts etc.I try to look into the Business Intellegent Studio, but I only see Report,Analaysis or Integration services - NO DTS.Can someone tell me where to find it. It used to be so easy in 2000.Thanks,Nasir

View 4 Replies View Related

MS SQL 7 Migration To Oracle 8i

Aug 24, 2000

Has anyone had any experience with the Oracle Migration Workbench? or using DTS to migrate MS SQL to Oracle? The Migration Workbench seems to work great but it is having parsing issues with some of the syntax in our triggers and procs (roughly 1025 of them). Are there other ways of handling these errors other than manually cleaning them up?

Thanks in advance.

View 1 Replies View Related

SQL To Oracle Migration

Nov 15, 2007

Hi All,

I would like to know the Migration plan from SQL Server 2000 to Oracle.

Is any one did this activity. Please send me document.


Siri

View 2 Replies View Related

Oracle To SQL Server Migration

Nov 23, 2005

Hi all

Does SQL Server has any equivalent of Oracle (PL/SQL) PRAGMA AUTONOMOUS_TRANSACTION ????

I am in a process of migrating Oracle database to SQL Server. I am facing trouble in the above mentioned thing, as I cannot compromise by not putting it.

Thanks in advance
Christian

View 1 Replies View Related

Migration From SQL SERVER To ORACLE

Jan 24, 2008

Our clint need to migrate from already runner database on SQL SERVER 2005 to Oracle 9i, WHAT will be basic and important issue we will face in this term and HOW we will handle with our functions and procedures created in SQL SERVER 2005 database... ???

regards

View 4 Replies View Related

Help On Oracle RDB Migration To SQL Server.

Jul 20, 2005

Hi,We need help on following things,1. Inputs on creating comments on the columns & Tables of a SQLDatabase & generating the sql script of that.2. Is it possible to call a .exe file in SQL server like followingcode in ORACLEcreate procedure CERT_VERIFY_PROCEDURE ( in :X Y by value )language SQL;externalname "CERT_VERIFY"location 'HOST_IMG:TEST_CALCS.EXE'with ALL logical_name translationlanguage CGENERAL parameter style3. We are using Rules for restricting data(now), We need inputswhether to use Check constraints or Rules.Thanks & Regards,Chandra Mohan

View 1 Replies View Related

Migration From Oracle To Sql Server (Urgent)

Sep 21, 2001

I want to do a data transfer but i am not sure how ..from oracle to sql server.

i want to know if its required to install the oracle client to configure so as to transfer data or not.

I heard from someone that if we change the win.ini file entry for oracle.ini and place the tnsnames.ora file i spcified location it will work but it does not what is the way to deal with..


How do i perform this with the odbc configuration for oracle..and use the same in the dts.

Thanks in advance.

View 1 Replies View Related

SQL Server Migration Assistant For Oracle

Mar 18, 2008

Has anyone ever tried to use this free software to migrate an old ORACLE 8.1.7 database to SQL Server 2005? I was just wondering if there were any "gotchas" I should be aware of before hand.
Thanks,
Robert

View 1 Replies View Related

SQL 2000 To Oracle 9i Migration Problems

Jul 20, 2005

Hi all,I am using the Oracle Workbench for migrating my DB currently on SqlServer 2000 to Oracle 9i. During the migration the following happensSELECT @tBaseTable = tBaseTable, @tDBColumnName = tDBColumnNameFROM tblColumnMain WITH (NOLOCK) left join tblCustomField WITH(NOLOCK) on aColumnID = nColumnIDWHERE aColumnID = @nPropertyIDgets converted toSELECT tBaseTable, tDBColumnNameINTOSPROC_PROPDATA.tBaseTable, SPROC_PROPDATA.tDBColumnName, FROMsa.tblColumnMain, sa.tblCustomFieldWHERE (aColumnID = nColumnID) AND (aColumnID =SPROC_PROPDATA.nPropertyID_);and gives the warning that complex outer joins maynot be reliablyconvertedOn the other hand the following codeselect @keyid = a.keyID, @pubs=b.pubs fromssd1 a left outer join ssd2 b on a.l_name = b.l_namewhere b.l_name = @namemigrates perfectly to Oracle asSELECT a.keyID, b.pubsINTO SPROC_JOINTEST8.keyid, SPROC_JOINTEST8.pubsFROM ssdash.ssd1 a, ssdash.ssd2 bWHERE (a.l_name = b.l_name(+)) AND(b.l_name = SPROC_JOINTEST8.name);with the same warning ...Could anyone enlighten me as to what exactly is the difference betweenthese 2 above cases.Also the migration bench seems to be removing nolocks and such stuff allaround. Any workaround for this is also needed.ssDash--Posted via http://dbforums.com

View 1 Replies View Related

SQL Server Migration Assistant For Oracle Question

Nov 24, 2006

I selected my source Oracle database and my target SQL Server database. I click the convert SQL button and it takes about 20 minutes to convert everything. Then what? The Migrate Data button is greyed out. I configured the linked server as is outlined in the instructions. The "Migrate Data" button is always greyed out.
I need to get this working soon so that I can convince the management team that moving to SQL Server is the way to go.
Thanks.

View 1 Replies View Related

Urgent: SQL Server Migration Assistant For Oracle

Sep 29, 2007

i am transfering an Oracle 10g database to SQL Server 2005. i have 2 pcs one with SQL Server 2005 with SSMA For Oracle Extension 3.1 installed, also with Oracle 10g client configured to connect the Oracle database in another pc. the other pc has Oracle 10g database server installed with SSMA For Oracle 3.1. whenever i try to migrate the data there is an exception which says

"Errors: SQL Server cannot access the source table"

i dont understand why its there. i hav successfully converted the schema and loaded them in SQL Server. can anybody tell me a soltuion asap.

S ]-[ /- | ]-[ /- N

View 1 Replies View Related

SQL Server Migration Assistant For Oracle Problem

Feb 15, 2008

I can connect to my Oracle database and I can connect to my SQL Server database. But the "Convert Schema" button stays disabled. What am I doing wrong? Anyone have experience using this tool?

View 4 Replies View Related

SQL Server Migration Assistant For Oracle Problem

Oct 6, 2006

I'm trying to make the business case to move our business databases to SQL Server 2005 from Oracle 9i. The SQL Server Migration Assistant for Oracle will be absolutely necessary for this to happen. However, I am unable to launch the assistant. It tells me I have an old version of java installed - but I don't. It is a new XP machine and I downloaded and installed j2sdk-1_4_2_12-windows-i586-p.exe which did not help (I rebooted). Why does it think I have an old version and how can I get this assistant working.

Any help would be much appreciated.

View 4 Replies View Related

Data Migration From Oracle 10g To SQL Server 2005

Dec 14, 2007

Hi,

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 ?

Regards,

Khurram

View 7 Replies View Related

Data Migration Oracle 7.16 To SQL Server 2000

Aug 22, 2006

Hi,

I have been asked to look at optimising a Data Migration Strategy for one of our clients. I am quite new to Data Migration (I'm actually a system designer!).

The migration is from a legacy Oracle 7.16 Db to a SQL Server 2000 environment.

The legacy Db has some large tables - 30 Million+ rows

Table/column Mapping is 1:1

At present we are using DTS to import into the SQL environment.

My question is: Is there any way to leverage the Oracle 7.16 export to speed up the migration process?

Any advice would be appreciated.

Many thanks

Mike

View 1 Replies View Related

Replication :: Oracle Migration (Distributor And Subscriber Databases)?

Jul 31, 2015

We are going away from a 2003 Windows Server OS with SQL Server 2008 R2 to a 2012 Windows Server with 2012 SQL Server. Both the distributor and subscriber resides on 2003 Windows Server and the focus will be to migrate those databases to the 2012 SQL Server.

 We would also like to avoid sending down a new snapshot due to logic in the replication process (major headache to clean up data).  what's the best approach in moving the distributor and subscriber databases without having to run a snapshot?  

In theory and needs testing:

1. Work with business users to get downtime

2. Stop sql apply so no new changes are going to the Oracle publisher database

3. Remove subscription, publication and distributor from current replication

4. Oracle DBA to clear out replication related objects - fresh clean slate

5. Use log shipping to apply last t-log and restore db with Keep_Replication

6. Set up new distribution, publication (keep existing object unchanged), and subscriber (without initialization) Will this work?

View 3 Replies View Related

Error While Data Migration From Oracle Row ID To Unique Identifier

Oct 12, 2015

I am doing migration from oracle11g to SQL server2012. Facing error while data migration from Oracle rowid dat typeto SQL uniqueidentifier using SSMA6.0

Errors: The given value of type String from the data source cannot be converted to type uniqueidentifier of the specified target column.

Refer above error.

View 2 Replies View Related

DTS Migration To SSIS - Oracle Unsupport Data Type

Mar 18, 2008



OK I migrated a DTS package from MS SQL 2000 to MS SQL 2005 64-bit SSIS. OK so I fixed a problem with a Double Global Variable... Now I am stuck at a connection to Oracle and it returning data... Here is the error message:

[Execute SQL Task] Error: An error occurred while assigning a value to variable "Remedy_Count": "Unsupported data type on result set binding 0.".

My SQL Statement is this:

SELECT COUNT(*) AS Expr1
FROM DB.MYTABLE

When I run it from the Query Builder it returned this:

EXPR1 = 2983

Here are some details from the General Page on the Execute SQL Task

ResultSet - Single row
ConnectionType - OLE DB
Connection - Oracle Provider for OLE DB
SQLSourceType - Direct input
BypassPrepare - True

In the Result Set I have The following:

Result Name - Variable Name
0 - Remedy_Count

So... what can I do to fix this. I have the Remedy_Count set as a:

EvaluateAsExpression - False
Value - 2414
ValueType - Double

I have tried setting the ValueType to Object and other things... Same error... I read some where about how SSIS has issues when Oracle returns a Numeric type data. Can someone help me with this? Anything you all can tell me would be great.

View 4 Replies View Related

SP2 In SQL2k5

Dec 28, 2007

Have people installed SP2 on SQL2k5 . Any problems / issues with that especially wrt failover clustering .

View 4 Replies View Related

DTS Scheduling In SQL2K5.

Apr 10, 2008

How to schedule a DTS package residing in LEGACY container, from SQL2K5?


------------------------
I think, therefore I am - Rene Descartes

View 5 Replies View Related

SQL2K5 Backup

Mar 30, 2007

In SQL2K EM you can right click a DB, and backup. Finally there is a option to schedule, which will create a job.

Is this option has been removed from SQL2K5?




------------------------
I think, therefore I am - Rene Descartes

View 7 Replies View Related

32-bit App Connectivity To 64-bit SQL2K5

May 9, 2008

Is there any reason why an application running on a 32-bit O/S that works with a SQL Server 2K database would not work with a SQL Server 2K5 64-bit database running on a 64-bit O/S?

It is my understanding that the connection layer (be it ODBC, OLEDB, ADODB, etc) would obfuscate any details regarding the underlying architecture... I wouldn't think the instructions sent would need to be any different, unless there is some deprecated call that is no longer supported.

Thanks in advance for any assistance!

View 5 Replies View Related

Sql 7 And Sql2K5 Living Together

Dec 17, 2007

Hello,

I have installed in a workstation (windows xp pro) sql 7 server (database engine + client tools).
After that I installed sql server 2005 with named instance (hostmyinstance).But I didn't end this installation.
I had a message saying me that there are problems on clients tools. moreover when I open a dos window and type "sqlcmd", I have the same message (client problems).
I then change my sql7 port to 1434 (which isn't the default port).But even with that my sql 2005 sqlcmd don't work correctly.
My question is :

can one install sql 7 (server + client tools) and sql 2005 (server + client tools) in the same machine ( a workstation [windows xp pro] )?

View 3 Replies View Related

Replication Between MS Access And SQL2K5

May 20, 2008

Dear All,

I have a need to replicate data between MS Access and SQL 2005 (Enterprise Edition).

Could someone give advice as to whether this is possible or not, and how I might go about setting it up?

Thanks
Krishna

View 3 Replies View Related

SQL2K5 INSTALL Path

Jun 10, 2008

I found that SQL2K5 doesn't prompt for file locations while installing - for binaries and databases. Is this the default behavior?



------------------------
I think, therefore I am - Rene Descartes

View 4 Replies View Related

Win2k3 R2 EE + SQL2k5 EE And 16GB RAM

Mar 27, 2008

For a SQL/2005 DB Server do I need the /3GB switch or not? I will have IIS running on the server; however, it won't be doing very much as the SQL Database is the main thing:

Windows 2003 R2 Enterprise w/16 GIG RAM 4 CPU (Virtual Machine)
SQL/2005 Enterprise Edition

Hardware: Dell Server 8 CPU w/32 GIG RAM running VM ESX V3

I know I need the /PAE switch to utilize Memory over 4 GB - the question is do I need the /3GB switch along with the /PAE switch?

DeWayne

View 1 Replies View Related

Partition View In SQL2K5

Feb 28, 2008

I have a partition view named StudentRequest with underlying tables StudentRequest_T1 and StudentRequest_T2.

Primary Key is on NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode

Partition View

Create View dbo.StudentRequestPartView with SchemaBinding
as
Select
NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode, AssignedCourseCode, AssignedSectionId,
LockAssignedRequest, UpdatedByPID, UpdatedDate, CreatedByPID, CreatedDate, AuditCommentId, DebugTrace
from dbo.[StudentRequest_T1]

union all

Select
NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode, AssignedCourseCode, AssignedSectionId,
LockAssignedRequest, UpdatedByPID, UpdatedDate, CreatedByPID, CreatedDate, AuditCommentId, DebugTrace
from dbo.[StudentRequest_T2]
go

Partition Tables

CREATE TABLE [dbo].[StudentRequest_T1](
[NumericSchoolDBN] [int] NOT NULL,
[SchoolYear] [smallint] NOT NULL,
[TermId] [tinyint] NOT NULL Check ([TermID] = 1),
[StudentID] [int] NOT NULL,
[CourseCode] [varchar](10) NOT NULL,
:
)

CREATE TABLE [dbo].[StudentRequest_T2](
[NumericSchoolDBN] [int] NOT NULL,
[SchoolYear] [smallint] NOT NULL,
[TermId] [tinyint] NOT NULL Check ([TermID] = 2),
[StudentID] [int] NOT NULL,
[CourseCode] [varchar](10) NOT NULL,
:
)


I am able to insert, update and delete records in the StudentRequest view using simple DML SQL statements i.e.

e.g.
Insert into Student Request (NumericSchoolDBN, SchoolYear, TermId,€¦)
Values(12345, 2006, 1,€¦)

Delete from StudentRequest Where NumericSchoolDBN = 12345 and TermId = 1

But when I use complex SQL statements using self-joins€¦

Insert into Student Request (NumericSchoolDBN, SchoolYear, TermId,€¦)
Select NumericSchoolDBN, SchoolYear, TermID,€¦.
From Student Request sr1 left outer join Student Request sr2 on
Sr1.NumericSchoolDBN = Sr1.NumericSchoolDBN and
Sr1.SchoolYear = Sr2.SchoolYear and
Sr1.TermId = Sr2.TermId and
Sr1.StudentID = Sr2.StudentID and
Sr1.CourseCode = Sr2.CourseCode

I get the following error and I can€™t seem to find any documentation that this is a limitation!!!...

Msg 4439, Level 16, State 6, Procedure Course_UpdateCoursePromotion, Line 232
Partitioned view 'STARS.dbo.StudentRequest' is not updatable because the source query contains references to partition table '[STARS].[dbo].[StudentRequest_T1]'.

View 5 Replies View Related

SSIS From SQL2K5 To MySQL

Apr 13, 2006

Hi,

We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client€™s machine. It worked like a charm in SQL 2K.

I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don€™t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5.

Do I have to add a reference of some kind or does 2K5 doesn€™t support ODBC destinations?

Thanks

View 8 Replies View Related

SQL2k5 Install - DTS/COM Error

May 7, 2008



Having problems installing SQL 2005 Developers Edition on a Terminal Services Server that already has SQL 2000 Developers Edition on it. I keep getting this error, no matter in what order I install packages:



Failed to install and configure assemblies M:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.


The help link says to set the DTC service up to run as a network service and start it, but it already is and is already running. Restarting the DTC and then clicking on retry yields the same error.

Any ideas? I've been beating my head against this machine for a couple of days now.

Thanks.

Phil Hershey


View 3 Replies View Related

Install SQL2k5 Using Different Cdkey

Aug 2, 2007



Hello everyone,

I need to get a server built for a client today. He has sent me the proof of purchase for his SQL2005. He is working on getting me the licence / cd key today (if thats even possible?).

I have our SQL 2005 server CD here that I wanted to use however when I get to the company name stage of the install the CD-key/licence code is greyed out. Any ideas on how I can change the embedded cdkey/licence to the clients so I can use our media today but with our clients cdkey?

This needs to be done today, its extremly important but due to a problem with logistics the media from the client was delayed untill mid next week.

Any help you can provide would be aprecaited.

Cheers
~Chris

View 4 Replies View Related

Continued Issues With SQL2K5 - SP2

May 7, 2007

I continue to have issues with SP-2 for SQL 2005 suite. It has now gotten so bad, I have multiple installations, including the TOOLS ONLY on my laptop failing, that I am going to stop ALL future installations of SP-2. The COM+ failures have not been resolved that I can determine. I have tried uninstalling, I have tried SP-1 before SP-2, every combination one can find. HELP.





Time: 05/07/2007 13:24:05.631
KB Number: KB921896
Machine: GA029-MDGRAVES
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
Backward Compatibility ENU 8.05.1054 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29549

View 3 Replies View Related

SQL2k5 SP1 Installation And Reboot

Feb 20, 2007

I installed SP1 for SS 2005 on a quasi-production server, which is why I didn't mind rebooting the server. Unfortunately, it's been 5 hours and the server still hasn't rebooted. (I see a gray screen and a pointer, and that's it... but there's still disk access happening. I'm not really sure what it's doing.)

What's the best way to avoid the 5 hour reboot in the future?

Thanks,
Robert

View 3 Replies View Related







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