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


ADVERTISEMENT

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

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 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

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 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 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

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

Setting Up Oracle Linked Server : Need Help : Sql2005 Running On XP Linking In Oracle 10.2

Oct 26, 2006

Is there any step by step help sites for setting up SQL 2005 linked (oracle 10) server?

I find MSDN articles but they referance winNT and 2000, I'm not getting very far and I'm not a DBA but need to get this working asap.

View 1 Replies View Related

Data Access :: Accessing Oracle Tables From Server Via Oracle DBLINK?

May 8, 2015

we recently got a scenario that we need to get the data from oracle tables which is installed on third party servers. we have sqlserver installed on ourservers. so they have created a DBLINK in oracle server to our sqlserver and published the DBLINK name.

what are the next steps that i need to follow on my sqlserver in order to access the oracle tables ?

View 2 Replies View Related

Trouble With: Linked Server To Oracle Using OraOLEDB.ORacle Provider

Jan 11, 2007

Hi--

 

I am running SQL Server 2005 on Win2k3:

Microsoft SQL Server Management Studio      9.00.2047.00
Microsoft Analysis Services Client Tools      2005.090.2047.00
Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML      2.6 3.0 4.0 6.0
Microsoft Internet Explorer      6.0.3790.1830
Microsoft .NET Framework      2.0.50727.42
Operating System      5.2.3790


I have the OraOLEDB.Oracle provider installed to the (C:oraclexe) directory.

I am having problems querying from linked oracle server.  When i setup oracle as a linked server and purposely enter an incorrect password the query i run tells me i have an incorrect password.   So it at least knows that.  when i set the correct password and run a query I get this error:

(i replaced the real server name with "someServer".)

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer".

 

This is how I set up my Linked server:

Provider: "Oracle Provider for OLE DB"

Product Name: SomeServer

Data Source: SomeServer

Provider String:  "Provider=OraOLEDB.Oracle;Data Source=SomeServer;User Id=MyLogin;Password=MyPassword"

 

 

The query I run is:

Select * from [Someserver].[schema or database]..[tbl_name]

 

Any help???  What am i missing?

View 3 Replies View Related

Migration From Db2 To Sql Server

Apr 21, 2000

HI all,
Could any one pls suggest me how to migrate from DB2 to SQL SERVER 7.0
Thank you all..

---Chow

View 1 Replies View Related

SQL Server Migration

Apr 24, 2008

hi,
We have machine where SQL 2005 server is installed.Atleast 3 web applications are running on it with data size 22GB in all. We need to migrate all data/tables/groups/users from this server to another server.On target server, SQL server 2005 will be installed.After that this migration activity needs to be carried out.what are options available to migrate to target server?
Microsoft migration tool? Any already existing stored procedure etc?which is preferred solution in such case?

Thanks for help
PD

View 6 Replies View Related

Migration Of Sql Server 7

May 21, 2004

Hi All,
Greetings,

We have
sql server 7
Sqlserver ServicePack SP3
Sort Order = 32
BuildNumber 7.00.961

on Windows NT,Now we are planning to upgrade operating system from win NT machine to windows 2000.
Please let me know what and all precausion do i need to take what and what all backup should be done apart from user database.
How do i take care of the users,logins,roles, DTS Job and Replication.

Please help me in this and also any links if u have on this topic

Waiting for reply
TIA
Adil

View 2 Replies View Related

Odd SQL Server Migration

Feb 20, 2007

Hello All,

Soon I shall have to migrate 2 medium sized databases from SQL server 7 to 2005.
Any words of wisdom, “how to�, “do and don’t� would be greatly appreciated.

Here are the details:
SQL 7.0 SP4, on Win2000
SQL 2005SP1,on Win2003

Sql 2005 needs to be installed on a new server (Win 2003), which will also be used as a web server (IIS6). I was thinking to go with a clean install for sql 2005 first, and after that to migrate the databases.

Thank you in advance,
Emily

View 9 Replies View Related

Migration To SQL Server 2k5

Jul 5, 2006



Hi all,

I have script written in SQL Server 2000.

When i tried to migrate to SQL Server 2005, it is working fine in the SQL Server 2005 installed in Windows 2003 Server. System tables(syscolumns, sysobjects etc)are created in "Database->Tables->SystemTable".

But when i tried to run in SQL Server 2005 installed in Windows XP, I'm facing the following problems.

1."The object 'CK_SavedSear_LastL_4B422AD5' is dependent on column'LastLoadedTime'

"ALTER TABLE DROP COLUMN LastLoadedTime failed because one or more objects access this column"

2.Moreover none of the tables had been created in "Database->Tables->SystemTable".

In both XP and 2003 Server, While installing, i have choosen same options.

Please anybody could help me to resolve this issue.

Thanks and Regards,

Nilavu

View 10 Replies View Related

Server Migration

Dec 15, 2006

I'm migrating 15 user databases from one server to another. The current production server is Windows 2000 Server SP4 and SQL Server 2000 Standard Edition SP4. The new production server is Windows 2003 Server and SQL Server 2000 Enterprise Edition SP4. The new server does not have the same directory structure as the current server.

I plan to detach the database, move the .mdb and .ldb files to the new server and then attach the database again. I'm not sure what to do with the master and msdb databases. Do I need to bring over the master? I know I need the msdb for all the job information. Since these are system databases, do I need to follow a different process? I want to get all these databases over to the new server so I can begin some parallel testing prior to the final cutover.

For anyone that has gone through this process, is there anything that I need to pay special attention to? Any issues moving from Windows 2000 to Windows 2003 or SQL Server 2000 Standard to SQL Server Enterprise Edition?

Any assistance would be GREAT!!!

View 3 Replies View Related

Migration To SQL Server 2k5

Jul 4, 2006



Hi all,

I have script written in SQL Server 2000.

When i tried to migrate to SQL Server 2005, it is working fine in the SQL Server 2005 installed in Windows 2003 Server. System tables(syscolumns, sysobjects etc)are created in "Database->Tables->SystemTable".

But when i tried to run in SQL Server 2005 installed in Windows XP, I'm facing the following problems.

1."The object 'CK_SavedSear_LastL_4B422AD5' is dependent on column'LastLoadedTime'

"ALTER TABLE DROP COLUMN LastLoadedTime failed because one or more objects access this column"

2.Moreover none of the tables had been created in "Database->Tables->SystemTable".

In both XP and 2003 Server, While installing, i have choosen same options.

Please anybody could help me to resolve this issue.

Thanks and Regards,

Nilavu







View 1 Replies View Related

SQL Server 2000 Migration To SQL Server 2005 Collation Change - Method?

Jan 24, 2008

Scenario
Recently moved a SQL2000 database to SQL2005.
Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS
Colaltion on SQL 2005 database server is Latin1_General_CI_AS

After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation.

What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' -
1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability>
on each varchar/char column

or

2) For each table
BCP out data
DROP TABLE
RECREATE TABLE (taking the new collation Latin1_General_CI_AS)
BCP in data

3) Other methods?

Thanks in advance
David.

View 4 Replies View Related

Migration From Sql Server Express 2005 To Sql Server 2000 Enterprise

Feb 12, 2008

hi, i need some help here,i made a simple data driven website in my development PC, at first, i used MS Access for my data base then i migrate it to sql server express 2005, and it works fine when i try to run it in my development PC with my IIS. but of course i will be deploying it to a real server, in our office were i will deploy my data driven site, we have a PC server Win Server 2003 with SQL Server 2000 Enterprise (im not pretty sure by the name but i know its not a free version, its something like a 2000 sql version with a word enterprise at the end).so my question is, i am developing an ASPdotNET site originally used SQL server 2005 express,how can i migrate my site to the Win Server 2003 and my database from SQL Server 2005 express to SQL server 2000 enterprisewill it work?? if not, what are the possible solution that i can do in cases like mine?i used Visual Web Developer 2008 Express Ed. in making my sites, and its DOES NOT allow databases in SQL Server 2000!!!!!it says "can't recognize the database"i hope you can help me with this.Thanks-SALAMAT PO....=) 

View 1 Replies View Related

Migration To SQL Server 2000

Jan 28, 2002

We are in the process of Migrating our SQL Server 7.0 databases to SQL Server 2000.
We have purchased two new servers for this process.
What is the best method for the Database Migration ?
- Copy Database Wizard ?
- DTS ?

View 4 Replies View Related

Migration From Access To Sql Server

Feb 28, 2002

I would like to migrate an access data to SQL Server. However, the Access database has an OLE data type field that stores word documents. Is there a way to handle this in SQL Server?

View 2 Replies View Related

SQL Server Physical Migration

Dec 20, 2004

Hi! I have an SQL server installation with a 6.5GB database online at a particular location. I need to move the Database to another location which is a 1000 Miles away.

I have an additional physical Server at the other location which I can use to Sync the database from the original location. Can anyone please guide me to the best strategy to sync the database from the original location to the new location with minimum downtime??

Any help would be greatly appreciated.

Thanks and Regards
Anish

View 2 Replies View Related







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