jwcolby
jwcolby at colbyconsulting.com
Mon Jun 13 12:22:57 CDT 2011
You can indeed do that but it only moves the data, not the indexes, SPs and so forth. Or at least that is my limited understanding. John W. Colby www.ColbyConsulting.com On 6/13/2011 12:54 PM, Francisco Tapia wrote: > database containers are generally non-backwards compatible (generally) I > haven't tested between 2008 and 2008(R2) but if you need to move your > database back you can use ssis to extract the data out of the 2008(R2) and > import it to a 2008 database. > > > -Francisco > > > > > On Mon, Jun 13, 2011 at 9:37 AM, jwcolby<jwcolby at colbyconsulting.com>wrote: > >> I own SQl Server 2008 developer (non-R2) and sql server 2008 R2. I have >> databases in R2 which I am unable to make play nice with 2008. Is there any >> way to get an entire database migrated backwards from 2008R2 to 2008? >> >> -- >> John W. Colby >> www.ColbyConsulting.com >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >