We are using BTS 2006 R2 running on SQL Server 2005. We will plan to interact with a SQL Server 2008 database using BizTalk 2006 R2 WCF-custom adapter.

Any conflict anybody facing regarding this scenario?

Hi Raja,

I was in a similar scenario sometime back. But we ran/developed a custom adapter to get some data from a SQL 2008 database. My adapter was polling based and bound to a SQL 2008 database to poll data based on some complex business logic. We had no issues in our case.

Regards,

M.R.ASHWINPRABHU

Hi Raja,

As M.Rashwinprabhu already stated above for his custom adapter, it will not be an issue to have your BizTalk 2006R2 WCF Custom Adapter interact with a SQL2008.
I've already seen this setup at a customer.

Did you try it?  If it works, great.  However, it won't be a supported scenario.

Refer http://msdn.microsoft.com/en-us/library/cc280356(v=sql.100).aspx for Support Policies for SQL Server Native Client in SQL Server 2008. It says its supports upto 2 previous versions which imply 2005 and 2000. So I'd suggest

1. you first upgrade the BizTalk Machine to SQL Server 2008 Client.
2. Let it run for a few days to ensure that this upgrade has not impacted the underlying BizTalk operations.
3. Then use it through the WCF-SQL to connect to and work with a SQL 2008 Database.

Also Refer http://msdn.microsoft.com/en-us/library/ms131687(v=sql.100).aspx for the SQL Server 2008 Native Client (OLEDB) related supported scenarios.

Regards