Export data from Cache into sql server

[prasa...@gmail.com]

I need to export data from cache database to sql server. Is it
possible please advise how to do it. Thanks!

regards,
Prasad

[Shaik Nayeemuddin]

Hi Prasad,

Is data.. in Globals or Cache Tables??

If data is in Cache Tables then you can use SQL Server DTS tool.

If data is in old global storage then we have write u r own code (front end code / cache routine) to export to SQL Server.

Regards,
Shaik

[Jeffrey Williams]

If the data is not currently accessible through a class object, you have
a couple of options.

1) Map the globals to cache objects
2) Create User Defined Queries and present as view or procedures
3) Extract data to file, import file to SQL Server

To get the data into SQL Server, the first two options can be used
through a linked server in SQL Server or using SSIS. Option 3 you can
use SSIS to pull the file.

HTH,

Jeff

[m3cl...@gmail.com]

This will also depend on which version of SQL Server you are using.
In SQL Server 2000, the DTS tool was great and very easy, as long as
your Cache data is exposed to SQL.
In SQL Server 2005, I couldn't get the SSIS tool to interact with the
Cache ODBC driver very easily. Certainly not as seamlessly as I could
with DTS. This may have improved since with the .Net client (I haven't
used SQL Server for quite a while now).
Anyway, my solution in SS2005 was to map the SQL Server tables using
the Cache SQL Gateway, and to then write a simple Cache SQL method to
copy the data over. This should work well whether you have your Cache
data exposed to SQL or not.

[Sukesh Hoogan]

Prasad

You can export Caché Data to a csV file and import it into MSSQLServer.

HTH
Regards
Sukesh Hoogan
Bombay, India
[Enterprise Resource Planning & Business Intelligence]

[Gustavo]

Hello All.   I have a problem with integration Cache Studio and Rational Rose. I'm using Rosé Cache Link. Somebody have any experience with it?   Regards.

---

Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.