Thursday, January 29, 2009 12:12 PM
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
Thursday, January 29, 2009 6:13 PMModerator
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
Friday, February 20, 2009 10:52 AMHi
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.
Monday, June 06, 2011 6:29 AM
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.
Sunday, April 22, 2012 9:02 PMcau you provide specific for import view schema to SSIS extract.
Sunday, April 22, 2012 9:03 PMHI CAN YOU PROVIDE SPECIFIC FOR SSIS PACKAGE