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
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
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.
Microsoft는 Msdn 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 Msdn 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.