> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Graham Brown > Sent: Tuesday, March 08, 2011 12:51 AM > To: [email protected] > 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 >
Well Duh !!! Of course it won't snarf in the R2 - that would make too much sense.... Thanks for the heads up on this - project is looming on my to do list that will prolly need to know this. Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ 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/69f310c05dd83c48a84ba3769ce1ecf8045b6...@tntriexevs02.triadhospitals.net ** 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.
