Bobby Heid
bheid at sc.rr.com
Tue Oct 19 20:33:56 CDT 2010
Shamil, We have run into this some also at work. Our solution has been script the schema changes with SQL Compare (by RedGate) and if data needs to be move, move it with SQL Data Compare (also RedGate). Bobby -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Saturday, October 16, 2010 8:07 AM To: 'Discussion concerning Visual Basic and related programming issues.' Subject: [dba-VB] MS SQL 2008 and MS SQL 2008 R2 Hi All -- It happens that MS SQL 2008 and MS SQL 2008 R2 have incompatible backup format - the ones created by MS SQL 2008 R2 can't be used to restore MS SQL 2008 databases. This issue is a RPITA here now as I have got upgraded both my development PCs to MS SQL 208 R2 and my Windows Hosting provider has MS SQL 2008 only and no near future plans to upgrage to MS SQL 2008 R2. BTW, I have checked several well known Windows Hosting providers - they do not have MS SQL 2008 R2 installed, and also no near future plans to upgrade to MS SQL 2008 R2. Or it there a feature which I'm currently missing which will allow to make MS SQL 2008 R2 DB's backup in MS SQL 2008 format? What happens is that if I setup a MS SQL 2008 db on my Web hosting, then work with it (e.g. via DNN), and then I get its backup downloaded and installed locally on MS SQL 2008 R2 - that goes smoothly but I then will not be able to make local backup using MS SQL 2008 R2 to uploaded it and restore on my web hosting site :( Thank you. -- Shamil P.S. Yes, I can setup MS SQL 2005 Express in parallel to MS SQL 2008 R2 - that works OK, but I didn't try to install MS SQL 2008 - would that work? _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com