You have different options
1. Create a linked server to SQL Server 2008 instance from R2 instance
Then use OPENQUERY or just linkedservername.dbname.dbo.table to get data
2. use adhoc query methods like OPENROWSET
3. Use SSIS export import wizard
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?