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 > >