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 |
|
lg123
Starting Member
8 Posts |
 Posted - 2013-01-24 : 15:08:40
|
| Hi,I want to export some tables from sql server 2008 to oracle 11g. I am planning to use SQL Server Import and Export tool available in SQL Server. In order to export and import from SQL Server database to Oracle database, should I pre-create the table structure in Oracle database? Please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-25 : 00:57:15
|
| Nope. You can create the objects on the fly inside Export Import wizard------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
lg123
Starting Member
8 Posts |
Posted - 2013-01-26 : 15:03:46
|
| Thanks, I just tried to start the export/import wizard and it gave me an error. I want to upload the screenshot with the error i am getting. Can someone tell me how to do it?I used windows authentication. I gave the server name and the database name. For the time being I am typing the error message here :The operation could not be completed. Login failed for user xxxxxx(Microsoft SQL Server Native Client 10.0) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-27 : 13:56:34
|
| you can upload the screenshot in some shared server and post the link here------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-27 : 13:57:57
|
| the error message suggests lack of permission for the login in the server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
lg123
Starting Member
8 Posts |
Posted - 2013-02-12 : 01:15:09
|
| Thanks. |
|
|
|
|
|
|
data export from SQL Server to Oracle