Data Migration From Oracle To SQL Server 2005

Oct 25, 2012

How to migrate Data from oracle to MS SQL Server or Vice Versa.

I came to know about 2 methods:

1) Using SQL Developer
2) USing ODBC.

View 2 Replies


ADVERTISEMENT

Nvarchar (max) Of Sql Server 2005 Is Not Accessible Through Oracle DB Link

Jun 16, 2012

i have created the DB LINK from Oralce 11gR2 to MS Sql Server 2005,am able to access the view of Sql Server from Oralce,but the Columns which have Datatype nvarchar(max) in Sql Server am not able to access through DB Link.

View 1 Replies View Related

Client Tools :: How To Sync Oracle 10g Database With SQL Server 2005

Jun 27, 2013

i have my oracle 10g database on my windows 7 and i install sql server 2005 on my windows server 2003 .now i want to sync my oracle 10g database with my sql 2005 means whenever i make any changes in my oracle table its automatically effect in my sql server also.

View 1 Replies View Related

Networking And Gateways :: DB Link From SQL Server 2005 (Big5) To Oracle (UTF8)

Mar 18, 2010

We got a big problem that we have a db link to connect to sql server(big 5).

In original setting, there is no Chinese characters in the data. We simply grab the data from sql server and do not have any issue. But now we have data with Big5. When we import the data into our Oracle DB, which uses UTF8, all the text becomes "?

Changing character set in DB is not possible. We need to convert the text into unicode format, or allow oracle/sql server to convert it automatically.

View 6 Replies View Related

Server Utilities :: Data Migration Using Datapump?

May 11, 2011

I got an assignment to create Oracle 11g db. I will be provided the full datapump export dump of an Oracle 10g db in linux. I need to import it to 11g Database in Windows. I have no information about the tablespaces, users etc I have created db with system,sysaux,undotbs temp and users tablespaces.

View 28 Replies View Related

Server Administration :: Data Migration Between Two Different Application?

Mar 9, 2011

We are planning to migrate data from an application called clintrace to another application called argus safety. Both the applications are related to pharmacovigilence safety operation. Both the applications functionality are similar. So both the database are having the same data though the table structures might be different. Both the database are oracle clintrace db is 9i and argus db is 11g.

View 8 Replies View Related

PL/SQL :: Oracle Data Migration

Nov 9, 2013

Send me sample data migration scripts to get knowledge on Data migration. 

View 10 Replies View Related

Oracle Dataset In Visual Studio 2005

Jun 1, 2008

i'm newbie in oracle and visual studio 2005..i running a sql-query in visual studio 2005 with the oracle dataset..i want the data that displayed is in the date range and the parameter is set by user..

EXEC ('
SELECT DISTINCT
XNP_TIMER_VIOLATION.VIOLATION_TIME,

FROM
XNP_TIMER_VIOLATION, ...

WHERE
(DATEADD(hh, 8,XNP_TIMER_VIOLATION.VIOLATION_TIME) BETWEEN ? AND ?)',@FROM_DATE, @TO_DATE ) AT npcrpt ;

View 4 Replies View Related

Data Migration From WORD To ORACLE?

Sep 20, 2011

I have a long file in WORD as I try to load it in ORACLE quotes become periods, ex:

insert into mytab values ('myname, 26);

when i copy this and paste it in oRACLE (UNIX environment), it translates as insert into mytab values (.myname.,26)..does not recognize the quotes.

I tried copying from word to notepad to ORACLE same problem..

View 5 Replies View Related

Server Utilities :: Data Migration - Remote Operations Not Permitted

May 10, 2011

I am trying to insert data in one of the tables called as tstcntr_mstr in ibpslive instance by ibpslive user.

My source tables are on ncfiiidv instance.

Query is as follows:

insert into tstcntr_mstr
(select * from tstcntr_mstr@dlink_ncfmdv)

Error that I get is remote operations not permitted on object tables or user-defined type columns.

Table tstcntr_mstr@dlink_ncfmdv contains types.

the migration of the data.

View 20 Replies View Related

Performance Tuning :: Oracle Data Migration

Jun 7, 2011

We have a data migration scripts written for oracle. Data is not huge but we are observing that the migration is faster in the development labs but is 5x slower in the production site.

The development Oracle setup is on Windows and Production setup on Solaris. I have attached the AWR generated for a period where migration was run for 3 hours and stopped due to slow performance.

Here is my initial analysis.

1) The first timed events is the DB CPU. Hence I feel the migration scripts can be modified to run in parallel so that they can finish faster. However here the question arises why it should run faster in development env if this is an issue.
2) I tried increasing the
a.large_pool_size set to 512M
b.sga_max_size set to 8G
c.sga_target set to 8G
from 0, 4G and 4G respectively.

I have attached the AWR and below are the etc/system contents for solaris settings.

* Begin MDD root info (do not edit)
rootdev:/pseudo/md@0:0,1,blk
* End MDD root info (do not edit)
set noexec_user_stack=1
set noexec_user_stack_log=1
* IBMdpo vpath_START (do not remove)
* default SCSI timeout is 60 seconds
* uncomment to change SCSI timeout * set sd:sd_io_time=0x1e
forceload: drv/vpathdd
* IBMdpo vpath_END (do not remove)

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

P.S. The awr report is renamed to .txt from .html to be able to upload the file.

View 6 Replies View Related

Migration From Oracle 10.2.0.3.0 To 11.2 On AIX 5.2 Server

Jan 26, 2012

Detail step by step description for Migration of ORACLE from 10.2.0.3.0 to 11.2 on AIX 5.2 Server.

View 2 Replies View Related

Migration From SQL Server To Oracle

Oct 10, 2011

I created some materialized view in Oracle database from SQL Server using Db Link.

When I selected the materialized view in Oracle database with where clause it is giving me following error.

SELECT * FROM COUNTRY_MV where country_code ='AWB';
ORA-00904: "COUNTRY_CODE": invalid identifier.

But when I write the column name inside quotes it works fine.

SELECT * FROM COUNTRY_MV where "country_code" ='AWB';

View 3 Replies View Related

Server Administration :: Oracle DB Server Migration Checklist

Apr 11, 2012

We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.

I was planning to ask the following questions.

1. Specifications of the current server and the new one.
2. Operation system (I think they will use same OS, just an updated one)
3. Can the business afford full downtime on current servers?
4. Size of the DB, because it can take hours to move large files.

And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything,

View 5 Replies View Related

Server Administration :: Migration Of Oracle From AIX To Solaris

Jan 4, 2013

We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp / impdp. Is there any other way to do it as well?

Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?

View 8 Replies View Related

Server Administration :: Migration Of Oracle Jobs

Nov 22, 2010

Recently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.

Is there is any way that we can migrate oracle jobs from 10g to 11g?

View 6 Replies View Related

Server Utilities :: Oracle Migration From 8 To 11gR2?

Sep 13, 2010

I have Windows server working Oracle 8.0.5.I have to migrate to another server that is Oracle 11gR2 on Windows 2008.Some say I can't do Export and Import directly.And some say DBlink is not working from 11Gr2 to 8.

What can be fewest step to migrate?Somebody try to use 'Oracle directory' and VB and Powerbuilder program to send data and DDL from 8 to 11Gr2.

migrating from Oracle 8.0.5 to 11Gr2 machine.

View 6 Replies View Related

Networking And Gateways :: Oracle 9i To Sql Server 2008 R2 Migration?

Apr 2, 2013

We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )

I do have two queries :

1) how to connect from Sql server 2008 R2 to different Oracle databases

2) How will other oracle databases connect to Sql server 2008 R2 database

View 2 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0

View 1 Replies View Related

Server Utilities :: Migration From Postgres Into Oracle Columns With Spaces

Jul 21, 2010

I have migrated from postgres to oracle entire databases however some tables have spaces how can they be removed and how can i found out all the tables in a schema with spaces?

View 8 Replies View Related

Installation :: Live Server Migration For 11gR2 Oracle?

Oct 15, 2013

Migrating the LIVE server to a NEW virtual machine.2 databases reside on the LIVE server, one runs in archivelog mode &other no archivelog modeOld server-Windows 2003 32 bit, oracle databases 11.1.0.7.0New-Windows 2008 64 bit,Oracle databases should be 11.2.0.3.0Just want to clarify the following1)When installing oracle, what would be the best option-create and configure a database / install software only(later create database using dbca) ?why? Just want to know if there will be a difference at all in these 2 methods.2)What is the best way to migrate the data in the database, datapump or rman (rman takes full backup in the present "live" so this can be moved to "new live" and can be recovered)? What would be the method with least downtime?(Once the data is transferred, the database in the "old server"will be deleted)3)The structure of the data files (folder path) are going to be different in the old and new servers, so I have to precreate the tablespaces, so will the impdp fail in this case?

View 1 Replies View Related

Server Administration :: Oracle Database Migration From 11gR2 32bit To 64bit?

May 28, 2012

"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"

Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition

View 4 Replies View Related

Server Utilities :: Migration From Sybase To Oracle 1 Table Fails With SQL Error ORA-01841

Jul 17, 2012

im trying to migrate Sybase 12.5 to oracle 11G R2 on linux all tables are fine expect one which fails with error

"SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range"

i have change the data type from CHAR to VARCHAR2 etc as for the datatype date shows as date on the tool - I'm using sqldeveloper from oracle.

View 8 Replies View Related

SQL & PL/SQL :: Why Yyyy Is Represented As 0005 Instead Of 2005

Sep 26, 2005

DB : Oracle 9i
Query : select to_date(sysdate,'dd-mm-yyyy') from dual
Result : 26-09-0005
Doubt : Why yyyy is represented as 0005 instead of 2005 and what should I do to make it 2005?

View 13 Replies View Related

Data Migration From 9i To 11g R2

Mar 9, 2011

We have our current production running on 9i and eventually want to migrate to 11g-r2. But the challenges are as follows:

9i production is running in San Francisco data center. 11g-r2 Production already setup up and running in Atlanta data center.

The database size is around 2 TB running on 9i. We are looking to transfer this to 11g-r2 and wondering, what options we have at our disposal: I was looking into EXP/IMP, but somebody said, dblinks will be much faster and reliable than EXP/IMP.

View 10 Replies View Related

Data Migration With XML Files?

Aug 25, 2010

we're planning a data migration from an application (oracle-based) to another (also with oracle db).

the origin is a ca. 80 GB database. so lots of millions of records are to be migrated. (before loading records into the destination tables, they have to be transformed).

the current concept is to receive all origin data in xml files, load them in a staging area (an own migration scheme in oracle), transform and load them into the destination tables.

we have three days for the whole migration (including extract from origin database, transform, load, backup after completion...).

my question is, that a migration with xml-files is a good concept. i think xml processing is much slower than doing the same with csv files. my proposal to migrate an oracle dump (so we got the original data in our staging area) was declined.

is migration mass-data with xml files good or are there performance or other issues?

View 2 Replies View Related

SQL & PL/SQL :: Script For Data Migration

Mar 23, 2012

I had a table with columns as below

employee_id
payroll_pay_week1
payroll_pay_week2
payroll_pay_week3
payroll_pay_week26

I have created a new table, so that instead of having 26 columns for payment amount for each week, I want to have one column for pay amount and one column to represent the week as below

employee_id
payroll_pay
payroll_pay_week

how do I migrate the data from old table to the new table?

View 6 Replies View Related

Remote Migration Of Data

Oct 30, 2012

Is there any oracle utility to do remote migration of data or it is possible only using some third party software.

View 1 Replies View Related

Data Migration From MySQL Database

Oct 31, 2008

I need to migrate data from Mysql database to Oracle11g database.

a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).

b) Is there any free tool available for the migration.

View 1 Replies View Related

Migration From Data Integrator To Java

May 6, 2013

how to migration from ODI to java.. How to work on this type of migration.

View 1 Replies View Related







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