SQL Developer


SQL Developer 2.1 - Associate Migration Repository errors


Hi,
I want to migrate a SQL Server 2008 database to Oracle 10.2.0.3. I created the MWREP user in the Oracle 10.2.0.3 db per the migration demo. When I try to Associate Migration Repository (right click active connection) get error message "SQL Error on Script Execution. Try deleting the repository before Creating Repository.". No details appear in the message log as to what the error is. I setup a logon trace but the trace file does not have any errors that I can see. I have retried several times and get the same error.
Any help is greatly appreciated!
Thanks,
Tom 
SQL Server 2008 is not yet supported, use a previous one...
Have fun,
K. 
Hi K,
Thanks for the info. I also tried with a SQL 2005 database but still get the same error associating the migration repository. Since associating the migration repository is only creating a repositry in an oracle instance it doesn't appear to relate to the version of SQL Server.
Regards,
Tom 
Right :) sorry.
I'd say you're missing privileges then. Can you grant that user e.g. DBA to test?
K. 
Thanks for the suggestion K. I gave the user DBA and sysdba but still get the same error :(
Regards,
Tom 
Hi,
Having same problem. Trying to migrate SQL Server 2005 database and on association is gives same error. User has full rights on ORACLE database. 
Hi,
I found the solution for this. When i had created the connection i had set the role as SYSDBA. So what i did is modify the connection to use the role Default rather than SYSDBA and the system created me the repository without errors.
Regards
Hamish Schembri

Related Links

Read only user access
Explain Plan and Autotrace Not Working in 2.1 EA2?
Too Many Tables?  Can I Display A Subset?
2.1 EA2: Date columns displayed wrong in Grid
Using REF with object table in SQL Developer
Custom Reports in SQL Developer and translations files
Inserting in VIEW does not work in GUI
EA2 - invalid option for ALTER SESSION when logging in to 9i DB via EA2
Issue regarding display
Sql developer 2.1 error messages
SQL Developer and instantClient in iMac
Source does not have a runnable target
SQL Developer 2.1 EA2 does not show any procedures
SQL Developer 2.1 EA2 and Version Control issue
git support?
SQL Developer 2.1 EA2 issue with TNS connections

Categories

ORACLE DEV
Java and JavaScript in...
Identity Management
Performance & Availabi...
Oracle Provider for OL...
Service
Industries Archived Fo...
Calendar SDK
Personalization
UIX
EBS on Linux
Integration - General
Berkeley DB XML
Berkeley DB Java Edition
SOA Suite
BPEL PM (Korean)
Backup & Recovery (Kor...
Portal (Korean)
XML Gateway (Korean)
Audit Vault
E-Business Suite on Or...
Business Intelligence ...
Business Intelligence ...
Planning and Budgeting
Product Hub
Query & Analysis
Enterprise Service Bus...
ServerStats
Archived BEA Dev2Dev F...
bea.education.weblogic...
opensource
weblogic.developer.int...
weblogic.developer.int...
WebLogic Portal Newsgr...
weblogic.developer.int...
Portlets
Primavera Portfolio Ma...
WebLogic Server - WebA...
Communications Data Model
Java Essentials
Conventional & Interru...
JMX
Java Sound
Sun Java System Identi...
Solaris Zones
Java Upgrade
Systems Development an...
Swing [Archive]
Sun Legacy Management ...
Solaris 9
Java Errors and Error ...
Sun Java System Access...
Oracle VM Server for S...
GlassFish Enterprise M...
Java Community Process...
Web Space Server
Oracle Communications ...
Sun ONE Meta-Directory
OpenSSO
Sun ONE Unified Develo...
開発ツール製品
Enterprise Gateway
Agile PLM
Oracle Tuxedo (Japanese)
Enterprise Metadata Ma...
OpenStack on Oracle Linux
Topliners
Eloqua10 Update Group
Benelux Eloqua User Group
Switzerland Eloqua Use...
CX Central
Oracle Marketing Cloud...
Java Lambda MOOC
Systems Track
Getting Started
OMC - Industry Solutio...
SwingLabs
Español
AROUG
SPOUG - Spain Oracle U...
Oracle Cloud Developer...
Uruguay
México
Oracle Container Cloud...
Containers, Docker, an...
See It
Generators
Resources
JUG Africa Social Group
Eloqua Benelux User Group
Java Database Connecti...
IA 64 Beta Program
Sensor-Based Services ...
개발자 (Korean)
EPM System Management ...
Identity Services
Communications Service...
北京 User Group
Swing
Sun Management Center
OTNカフェ
Big Data Connectors/Ha...
Technical Questions
Oracle Cloud - General...
Transportation Management
Demand Management
Argentina

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App