Trouble moving db to another sql2005

I'm trying to copy a database from my machine's SQLServer2005 to a
production machine. I tried a restore from backup, which gave me an
error that the on disk structure was 611 and the production machine
supports 539. I've looked around and found similar problems, but those
were all involving SQL2000. These are both 2005. Oddly, the management
console of the production machine is version 9.00.2047.00, indicating
it's later than my machine's 9.00.1399.00. But that is the console,
not the db version, which I can't find.

My admin says that there is a big patch (or service pack) that
surprisingly isn't on the production machine and he'll do that
tonight. Does anyone know if that will cure the problem?

I don't even know if a restore will actually accomplish my goal of
getting the db into production. As you can tell, I'm not SQL2005
expert.

The db in question is the one that handles the authentication and user
profiles for asp.net version 2 (aspnetdb.mdf). I wrote the app using
sqlexpress am an now moving it to sqlserver. It works fine on my
machine and a test server, but apparently the production server is a
bit behind the times.

Any advice appreciated. I tried the script wizard but have no idea how
to use that.
.

Relevant Pages

  • Informix 7.30 (I know!)
    ... We have a need to migrate the database from a running Production server on to a Pre Production machine which will eventually replace the Production Machine. ... We plan to take level "0" back from the Old box, restore to the new box and then apply the delta using scriptsto bring the data in sync. ... Is there a way by which after we have taken a level "0" backup, we can then take another backup of whatever changed after level "0" and apply that to database using some informix utility.I am not sure if a Level "1" will do the job as while the Level "1" is being restored we will have a down time. ...
    (comp.databases.informix)
  • Restore database with no log
    ... I'm trying to restore a database backed up a production machine onto ... I don't want to restore the transaction logs ... Note that I cannot additionally specify FILE = N'CPTS_Log' or FILE = ...
    (comp.databases.ms-sqlserver)
  • Re: Windows Tries to Reinstall Apps whenever certain other apps are Run?
    ... Zoyanot wrote: ... A month back may be too much for a production machine. ... When you choose to restore your computer, you will see a calendar on the left with dates in bold type. ... System Restore works best when you restore to a date only a few days back, ...
    (microsoft.public.windowsxp.general)
  • Re: BIP and Windows SharePoint Services
    ... I guess I will try to find a working scenario on ... a test server and transfer it to the production machine. ... Regards, ...
    (microsoft.public.sqlserver.olap)