Linked Server and Alias

I have a production sever and a development server with Identical db's
(two physically seperate servers)
I also have a production reporting services box, and a development
reporting services box. Currently I archive data from production DB
to the prodcution RS server, so that the prod RS is our data
warehouse. We use views to point to our data on the reporting box
such as DBname.dbo.tablename from a central DataWarehouse database
while the actual data is in seperate db's depending on where it was
archived from
I want to be able to run reports from our development RS server
pointing to the development DB, not the development RS (I dont want to
keep a development copy of our entire data warehouse)
Can I create a linked server / alias combination so that on the
development RS box "DBname.dbo.tablename" would actually point to
DVServer.someotherDBName.dbo.tablename?
Can I do it without having to create a synoym for each object?
Thanks
> Can I do it without having to create a synoym for each object?
I have been asking for synonyms for other tiers of objects (e.g. databases,
servers) for some time. If you feel strongly about this, please vote:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=288421
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=311079