Hi, 

Here's my scenario:

• 2 Windows 2003 Servers (SERVER1 & SERVER2)
• SERVER1 has SQL Server 2000 and a low number of transactions
  
• SERVER2 has Pervasive SQL v10 and a high number of transactions
  

I want to make scheduled operations from SERVER1 to SERVER2. In particular each operation is selecting some data from SERVER2 and then dumping it to SQL Server on SERVER1. The connection between the two servers on a DB tier is made with a SQL Server technology named Linked Server thus needing a common protocol (ODBC or OLEDB).

Which of them may be a better solution for performance and stability when doing those type of operations on the Pervasive connector side?

Thanks in advance.

Juan David Hoyos Rentería
 

Both OLEBD and ODBC offer the same basic performance.  

You might be able to use either option in a Linked Server.

 Another option is the Pervasive Integration offering (http://ww2.pervasive.com/Integration/Products/Pages/PervasiveDataIntegrator.aspx).