Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2009-08-06 : 17:37:24
|
| We are migrating our Oracle databases to SQL Server using the SQL Server Migration Assistant for Oracle. Would anyone happen to have any experience with this utility and know what permissions are required in SQL Server? We have the extension pack installed on the SQL box - made a specific account and gave db_owner permissions to the sysdb, ssmatesterdb and the user database that will contain all the tables being migrated from Oracle. Problem is something fails during the process. I made the account a sysadmin and the migration works just fine. Any thoughts? |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2009-08-18 : 10:59:49
|
| No one has used the SQL Server Migration Assistant for Oracle? |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-08-18 : 14:58:25
|
| I have, but it is pretty new so don't expect to find people with a lot of experience with it.I did not run into the problem you are encountering. You are going to have to look closely at the error messages that were generated.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
Migrating from Oracle using SSMA