Combining multiple databases into one

Hi all, I have a distributed database environment. I need to bring all the data from the distributed centers into one central database. I have replicated all data from the different centers into their databases at the central location, I now need to be able to view the data as if it were in a single database. I have added a field that identifies the source of the data in all the different databases. I've tried replicating from the diffenrent databases into one, but I just have a feeling there should be an easier way than having another copy of the same data in the same location.

The distributed database structures are similar.

The configuration is

Windows Server 2003
SQL Server 2000 SP4

please help anyone.I had the same issue 5 years ago but ended up redesigning whole system so all regions look at the same database. It took me a year to do this.

The draw back is slowness in remote regions. Like New York - Tokyo.

If you are on the same network you can probably link all servers and no need to replicate data just for this. I do replicate data for disaster recovery only.|||

Quote:

Originally Posted by iburyak

I had the same issue 5 years ago but ended up redesigning whole system so all regions look at the same database. It took me a year to do this.

The draw back is slowness in remote regions. Like New York - Tokyo.

If you are on the same network you can probably link all servers and no need to replicate data just for this. I do replicate data for disaster recovery only.

Bandwidth is also a problem for me and the remote centers are setup to operate in a distributed environment.

Colors hadling with ReportViewer

Hello,
My doubt is how to change in a LocalReport environment the text color of a
textbox of a report depending on certain condition at runtime.
I will thank any help.
Sincerely,
Arturo Carrión
at Tiempo HardHello Arturo,
My understanding of this issue is: You have a reportviewer control using
the Local Report. And you want to control the color of a textbox in the
runtime. If I misunderstood your concern, please feel free to let me know.
Based on my research, you could only control the color in the report. You
could use the Expression to control the color.
Expressions Commonly Used in Reporting Services
http://msdn2.microsoft.com/en-us/ms157328.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Wei,
Until this moment, I have not been able to enter the link that you gave me
because it gives an error of "Server is too busy".
I will try it later, then I tell you.
Sincerely,
Arturo Carrión
at Tiempo Hard
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escribió en el mensaje
news:bmTJvs%23THHA.1860@.TK2MSFTNGHUB02.phx.gbl...
> Hello Arturo,
> My understanding of this issue is: You have a reportviewer control using
> the Local Report. And you want to control the color of a textbox in the
> runtime. If I misunderstood your concern, please feel free to let me know.
> Based on my research, you could only control the color in the report. You
> could use the Expression to control the color.
> Expressions Commonly Used in Reporting Services
> http://msdn2.microsoft.com/en-us/ms157328.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Jackpot!
I realized that most properties of a textbox accept an expression instead a
value.
Thanks, Wei
<tiempotecnologia@.newsgroup.nospam> escribió en el mensaje
news:eaynrmEUHHA.1636@.TK2MSFTNGP02.phx.gbl...
> Thanks Wei,
> Until this moment, I have not been able to enter the link that you gave me
> because it gives an error of "Server is too busy".
> I will try it later, then I tell you.
> Sincerely,
> Arturo Carrión
> at Tiempo Hard
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> escribió en el mensaje
> news:bmTJvs%23THHA.1860@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Arturo,
>> My understanding of this issue is: You have a reportviewer control using
>> the Local Report. And you want to control the color of a textbox in the
>> runtime. If I misunderstood your concern, please feel free to let me
>> know.
>> Based on my research, you could only control the color in the report. You
>> could use the Expression to control the color.
>> Expressions Commonly Used in Reporting Services
>> http://msdn2.microsoft.com/en-us/ms157328.aspx
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>|||Hello Arturo,
Glad to hear the information is helpful.
If you have any question, please feel free to let me know.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

collecting data from different mdbs

Dear netters,

I'm trying to set up a db architecture for a community school environment with the following restrictions:
- each school uses a simple application, storing data in an an .mdb file
- school data must asynchronously update a central server (SQL server) that stores data from all the school files and publishes them on the www
- no permanent interner connection is guaranteed (schools work offline and update the server periodically)

I'm checking MS solutions for the above requirements. Is "replication" the right place to start? Should I look into some other capability of Ms products (wharehousing?)?

I would appreciate some guidelines on how to organise my search for solutions.

Thanx in advance,

Vas.Mail the req's and I'd be glad to consult...cheap rates!

No replication is not the place to start..

A entity relationship model is...

Actually a process model diagram is...|||come on, we're talking about school system here! they can't afford to pay teachers the rate that they deserve! ...and what are your rates? :)

but you're right, - process model combined with the erd will give us an idea here on how to tackle this.