I am building an application that pulls in data from a Linked SQL
Server.
The linked SQL Server has a database instance for each Month End going
back ~16 Months. The database schema is the same on all databases. Each
database is named EOM_yyyy_mm.
The data on the Linked SQL Server is NOT Updatable. It is a data
wharehouse.
How would on go about using views to query anyone of the databases from
the Front End? Would my application need to build the SQL dynamically
similiar to a Pass-Thru Query? I'm fine with that, and have no problem
doing it via code. But I just wanted to confirm that is what I should
be doing.
Keep in mind once it is moved to a production server, nobody can make
schema changes. I am on the development (programming) side, not the dba
side.Anyone?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment