Unanswered: Restoring a Database from SQL Server to MSDE
I built a database using SQL Server and I want to deploy it to an MSDE installation on another computer. I tried to do this by making a backup of the SQL Server database and creating a new database based on the backup (using a tool: Vale Software MSDE Manager).
When I try to run the application (its Java connecting through JDBC), it says it cannot find anything in the database (can't find stored procedures, tables, etc). When I run queries on the default database (the ones that install with MSDE), it works. What is wrong?
The error message:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'sphere'.
Error code: 208