I heard someone say they were having issues getting a version of SQL R2 to run - just yesterday. I'll pass this along.
Thanks, John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Graham Brown Sent: Tuesday, March 08, 2011 2:51 AM To: ProFox Email List Subject: [NF] SQL Server 2008 R2 vs SQL2008 Hi all Thought I'd share this because it has been driving me nuts all weekend. I have a SQL 2008 R2 database which needed to be deployed to SQL 2008 Workgroup Edition. No problem? However SQL 2008 will not accept databases from R2, although they are both SQL it is a different animal altogether. The answer is to use R2 Enterprise Manager, right click database, tasks and script database. From the advanced option choose "Script as " and make sure this says 2008. There is also an option to script schema, data or both. Finally run the script generated Hope that helps someone. Graham --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) application/ms-tnef --- [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.
