CR XI - "INTERSYSTEMS CACHE DB's"

[OrionStar]

I'm having some issues with linking tables. I've narrowed it down to being the TYPE of "platform???" that we are running our databases on. We have several SERVERS in our offices and we mainly run SQL SERVER DB's on most.

However, we have our BILLING data tables running on INTERSYSTEMS CACHE SQL.

What I've done is had my DBA transfer a few tables from the server running INTERSYSTEMS CACHE to the SQL SERVER, server. When the tables are transferred/copied, I can perform LEFT OUTER JOINS with no problems and VERY quickly access the data I need. But I'm wondering WHY I cannot LINK these exact same tables on the INTERSYSTEMS CACHE SERVER?

Does anyone know of a way to work around having to physically copy/transfer tables OFF OF the INTERSYSTEMS CACHE to SQL SERVER???? We have hundreds of tables and so, I'm hoping to avoid having to do this?

Someone mentioned creating a COPY of the table on SQL and "linking" it to the main table on the other server? I think this will jeopardize productivity on our main LIVE data tables, ...right???

Thanks


Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[IdoMillet]

Linking doesn't create a copy. It creates a virtual table that gets accessed on the remote server, but behaving as if it's local. You need to talk to your SQL Server DBA, he/she should know how to test this approach.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[OrionStar]

Ok, thanks... they have decided to COPY instead of link, as they are concerned about strain.... on our production server. I would agree since this particular server is SLOW.. but you know what IT'S BRAND NEW!!!

It must be the INTERSYSTEMS CACHE SQL format that is slow. It has to be, because when we copy the tables out of this server and place them on an SQL SERVER, server then I get serious speed.

Thank you for your input.

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?