importing a view in Sql Server 2008

Question

Hello All,

                   I want to import a view which is reated in Oracle.

                   But i want to import this in Sql server 2008 so that it could not change my actual database

              If  i made some changes in that.So how could i import a view in sql server built in Oracle 

Answer 1

Well, that depends on what you understand by "Import". You will have to create your own view definition based on TSQL for that. You can sure reference the tables in the Oracle database, but you will have to port it to TSQL.

Jens K. Suessmeyer

Answer 2

Hi
if you just want to reference this view in your database, you can try :

CREATE SYNONYM [schema].[synonymName] FOR [serverName].[Database].[schema].[Objectname] 

then you can access [schema].[synonymName]  in your database.

Answer 3

There are many ways of doing so:

you can create a DTS or SSIS package to do so.

Secondly, use SQL Server Migration Assistant for Oracle (SSMA for Oracle), which will do this automatically.

Thanks..

---

-Nitin Pawar

Answer 4

cau you provide specific for import view schema to SSIS extract.

Answer 5

HI CAN YOU PROVIDE SPECIFIC FOR SSIS PACKAGE