1
vote
1answer
21 views

cons of linked server providers not running in “allow in process”

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
2
votes
1answer
373 views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...