On Tue, Apr 10, 2012 at 7:54 PM, Rafael Copquin <[email protected]> wrote: > I have built a new app using SQL Server Express 2008 as backend and VFP9 > as front end. > > My client has SQL Server Professional 2008 installed in his server. > > I backed up the test database with empty tables from SQL Server > Express, took it to my client's office and tried to restore the backed > up database into his server. > > I receive the following error message: > > (translated from the Spanish error message) > > The database was backed up in a server version 10.50.2500 That version > is not compatible with this server which uses version 10.00.1600 > Restore the database in a server that admits such backed up database or > use a back up compatible with this server. > > Now, I could write a script to generate the database and all the tables > from scratch, but the system has a humongous amount of tables, with > numerous fields, constraints, indexes, etc. It would a PITA to do that. > > Is there a way to convert the Express copy into a Professional copy, so > it can be restored directly? Or a utility to generate the script mentioned?
I don't think the Express/Professional is the problem. 10.50 is SQL 2008 R2, 10.00 is SQL 2008. Sorry, I don't have a solution. Enterprise manager should be able to generate your scripts, just make sure you script the data & other important information (keys, etc). -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+l4rvyhcr8b8ic_wfk5rx-rbmwdl8yesgnnzc3gtjh...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
