[dba-SQLServer] Is there any way

Hello John,

I second Francisco's recommendation of Redgate.

Using SQL Compare, and SQL Datacompare, you can (carefully) prepare scripts
that will re-create the db and the data - not sure how it will work with
gazillions of records, but I would not expect it to work well, but for
thousands it should be ok,  you can probably manage the big tables
 yourself.

BTW, did you know that you can link servers in SSMS, and then you can do the
following

insert into [servername].[dbname].[dbo].[tablename]
select .... from localtablename

I cannot work without Redgate SQL Prompt BTW, I love it.

Mark



On 13 June 2011 18:25, Francisco Tapia <fhtapia at gmail.com> wrote:

> 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
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>