[dba-SQLServer] Is there any way

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
>



More information about the dba-SQLServer mailing list