Francisco Tapia
fhtapia at gmail.com
Mon Jun 13 12:25:17 CDT 2011
You can run a trial version from redgate's SQL compare to grab all that info in a really simple manner, you get 14 days trial w/o limits. Better than spending the time to roll you own. Sent from my mobile On Jun 13, 2011, at 10:23 AM, jwcolby <jwcolby at colbyconsulting.com> wrote: > 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 >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >