quinta-feira, 29 de janeiro de 2009 12:12
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
Todas as Respostas
quinta-feira, 29 de janeiro de 2009 18:13Moderador
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
sexta-feira, 20 de fevereiro de 2009 10:52Hi
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.
segunda-feira, 6 de junho de 2011 06:29
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.
domingo, 22 de abril de 2012 21:02cau you provide specific for import view schema to SSIS extract.
domingo, 22 de abril de 2012 21:03HI CAN YOU PROVIDE SPECIFIC FOR SSIS PACKAGE