Solved

Migrating an SQL 2008 database to Oracle 12c

Posted on 2016-11-07
3
64 Views
Last Modified: 2016-11-15
Hi I have been going in circles attempting to migrate one 6 GB database from MS SQL 2008 server to an Oracle Linux with Oracle 12c database.
I'm trying to use an online task using Developer 4.2, the process seams to run successfully each time but no data gets migrated, users and log in is migrated.
Can anyone help me identify what my issue may be, someone told me to follow this doc however this is for 11g and options on this doc do not exist in the Developer version I'm using, so I have not been able to complete.
I have used the steps provided on an Oracle video for developer 4 and this is the one with no data moved.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

Regards,
Atorex
0
Comment
Question by:atorex
3 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 41878336
Are tables and views etc. migrated, too, just no data?
0
 
LVL 24

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 41883690
Hi!

When you log into your SQLServer and Oracle Server make sure that those users are DBA users and have all privileges necessary to do the migration.
If you have successfully migrated the tables but not data check select rights on the tables in the SQL Server database and INSERT rights on the tables in the Oracle database.

Regards,
     Tomas Helgi
0
 

Author Comment

by:atorex
ID: 41886283
Sorry I was away for a couple days,
I get all the users and table schema I can browse the database and login with the imported users from the SQL database just no data at all when I query a table there is no data all empty.
For login I'm using system for Oracle and sa for SQL, I just can't figure where I'm missing something the process keeps running and completing after like five or so hours, the db is about 6 GB in size.

Regards,
Atorex
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle Finace 3 47
linux apache localhost dev laptop 5 34
Anti-virus for Linux Server 15 86
VB.Net - CSV to Oracle table 4 30
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now