Backup SQL 2000 SP4 and Restore on SQL 2005

Does anyone know if this works to where the data is viewable/usable?

I have an application that takes datasets out of the SQL database. We decommisioned our old SQL 2000 SP4 machine and brought in a SQL 2005 Server. What we did was backed up the old database and then restored it on the new Server.

Now the application does not see the old datasets but will collect new ones that are viewable. We can import older datasets but we have nearly 27 GB of data, which our DBA can see the old tables in Enterprise Manager but our applciation can't see it.

I'm thinking it might be a schema issue or the way that 2005 translate the odler 2000 SP4 database. Does anyone know, or have they run a back up on a older 2000 Server and then restored it to a 2005?

Thank you.

David

Can you see the data inside the new management studio.

|||

Yes. But not within the other application

My main question is has anyone tried to run a Backup of a SQL 2000 SP4 and restore in a SQL 2005, and was the data accessible?

|||Hi,

could be a owner / schema issue, depending which owner / schema the objects had and now have. The best thing would be to analyze what the application tries to query using the profiler. There you would see which user is trying to gain access to the database through the application and which objects are tried to access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de