Dump of sql database 1

[mikeyb123]

Is it possible to take a dump of the sql database so we can query directly rather than through the defined reports.

I don't want access to the live database, but say, the day before???????

anyone tried this?

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[RCorrigan]

Did something similar with SECC3 using ODBC access to the data ..... much cheaper to buy propriatory ODBC drivers than upgrade the Symp Server !!!!! Will try and find which / how etc

<Do I need A Signature or will an X do?>

 

[RCorrigan]

Driver came from Data Direct

http://www.datadirect.com

- Hope this helps

<Do I need A Signature or will an X do?>

 

[mikeyb123]

cheers.

I'd give you a star but it's taken 3 goes to get this post on........

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[RCorrigan]

<Do I need A Signature or will an X do?>

 

[BDSAINT]

We use ODBC with perl and wrote some perl scripts to dump the entire database nightly to a storage repository. That way we can keep small amounts of data on symposium. Seems the server runs better when your not storing call by call and 90 days of interval reporting

Dusty