SQL SERVER

[vj_meghani]

HI

I am tring to load table from SQL server to Oracle. but some how i am not able to see the actuall table that i hv to transfer it.
I am able to see some of the Master.dbo. systemtable, but none of the table that i hv transfer.

Can anyone pls help me on this.


Thanks
vaishali

[Amos.Rosmarin]

Hi,

Check your odbc settings. Make the db you want to reach your default db
and make sure you have permissions to see al tables you need.


HTH,
Amos

[vmcburney]

Amos is right, it looks like you are loading the tables of the "Master" database from your SQL Server. This db will have no user tables in it, only system tables. You database name you are passing to the ODBC driver may be missing or incorrectly spelt. You could also try making the correct database the default database for the database login you are using from SQL Server Enterprise Manager.

[vj_meghani]

Thanks a lot. I am now able to view the table and even transfer the data


thanks

vaishali

[vj_meghani]

Hi. I am able to transfer all the table from sql server to oracle database.
Do U have any idea how do i transfer sql server store procedure to pl/sql . i am able to import the store procedure file how to conver them.

thanks
vaishali

[shawn_ramsey]

Vaishali,

I am pretty sure that this is not a something that you will be doing in datastage. :D

I have seen some tools advertised that claimed to take an Oracle Stored Procedure and convert it to a SQL Server one, but not the other way around.

[shawn_ramsey]

I need to correct my previous statement. There does seem to be tools out there that convert the stored procedures. A quick google search turned up the following:

http://www.ispirer.com/products