question

nandhini.ramanujam87 avatar image
nandhini.ramanujam87 asked

Oracle External table equivalent in SQL Server

Hi, I am doing migration from Oracle to SQL Server 2012. Kindly suggest to convert Oracle External table to SQL Server. Whether shall I use Filetable or normal table. Regards, Nandhini R
sql-serversql-server-2012migration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Ah, you want to use [OPENROWSET][1]. From what I can tell of Oracle, that's the equivalent within SQL Server. [1]: http://msdn.microsoft.com/en-us/library/ms190312.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nandhini.ramanujam87 avatar image nandhini.ramanujam87 commented ·
Thanks for your reply... I am trying on the same.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.