I will answer my own question. Investigating the SQL Server Management Studio, I found the scripting tool is built into it. I ran it and generated a script of the database with all its objects (tables, constraints, indexes, etc)
I ran it in the SQL Server Professional and it created the database and the tables as expected. Fantastic! Rafael Copquin El 10/04/2012 03:54 p.m., Rafael Copquin escribió: > 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 > > [excessive quoting removed by server] _______________________________________________ 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.
