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? Thank you all Rafael Copquin _______________________________________________ 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/[email protected] ** 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.
