I have a production server with a legacy application which requires Microsoft SQL 2000. I have written several asp.net based reports that query this data (read only). Some of the functionality that I would like to add to our reporting would benefit from features of a more modern version of SQL (i.e. Multiple Active Result Sets). I have setup a second server with SQL Express 2008 R2 and was considering replicating a copy of the data from the 2000 server to the 2008 server and updating it regularly. Any suggestions on a better solution? I cannot alter the 2000 server. Is it possible to link the tables in 2008 so I can access the 2000 data and utilize the added features of 2008?
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.