May 30, 2008 at 4:55 pm
Is there a way to merge multiple SQL 2005 Express databases so that I can generate reports on the consolidated data?
Can this be done via an SQL command or should I seek an external program for the task. Thanks
May 31, 2008 at 9:26 am
Sounds to me like you're angling towards using some kind of table-wise UNION setup to get your reports. That's certainly something that can be done vai T-SQL.
Depending on what you're doing - it might be better to build a "composite database" using SSIS scripts to import all of the data from each of the various DB's into one, and then run your reports from there, but your lack of specifics and somewhat confusing wording makes it hard to get at exactly what you're up to.
Hopefully this nudges you in the right direction. Otherwise - you might consider rewording/supplying more specifics on what precisely you're attempting to do.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 2, 2008 at 1:41 pm
How about using linked server or OPENQUERY technique?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply