[dba-SQLServer] sql server migration assistant

Mark Breen marklbreen at gmail.com
Mon May 24 03:32:27 CDT 2010


hello John,

I also have used it to upsize - once from Oracle to SQL and once from Access
to SQL.  On both occasions it worked very well,

be careful to review the reports, sometimes a table is not migrated and you
must notice this and fix the issue (nulls in the PK field in Access on one
occasion)

Thanks
Mark


On 24 May 2010 08:10, Michael Maddison <michael at ddisolutions.com.au> wrote:

> I've used it once with no problems IIRC.
> I didn't have much data to deal with though.
> IIRC it lets you specify datatypes and lengths before you convert, gives
> a comprehensive report and lets you save the config.
>
> Cheers
>
> Michael
>
> Has anyone used the SQL Server Migration Assistant for SQL server 2008?
> Pros / cons / comparisons
> to the upsizing wizard?
>
> I just looked at it today for the first time and it seems pretty good,
> but I haven't done an
> extensive eval.
>
> --
> 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
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.819 / Virus Database: 271.1.1/2884 - Release Date: 05/21/10
> 04:26:00
>
> _______________________________________________
> 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