Change Sql7.0-Sql 2000

[simma]

Hello
We are moving from Sql 7.0 to Sql 2000.I have 60 reports and how would I be affected by change.How do I change the location of reports?
Thanks

 

[synapsevampire]

If you're using ODBC, the transition should be relatively gentle, just change the settings in the ODBC.

If you used a direct connection (or another means), and the name of the server changes, you'll need to change the connectivity for every report. Try to convincec them to use the same name if you aren't using ODBC.

I haven't had to do this in large scale recently, I believe there are utilities to handle changing the data source now, hopefully someone will chime in with that part.

If you have structural changes, you'll have to either alter the reports or the underlying data sources (SP's/Views).

If you used Views/SP's, then you are fortunate, the Views/SP's get changed and the reports function.

I always suggest using Views or SP's for reports.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[simma]

Thank you so much....I was off yesterday from work and today morning I come and my DBA told me they are upgrading...Its a shock to me.I said stop everything and posted this thread.Now I have an idea what to do.This is of great help.I used stored procedures with direct connections.I will request them to use same server name.
I will wait for advice on changing data source..