[AccessD] SQL Server Migration Wizard

Hi John,

Another tool I've used is called MUST (http://www.upsizing.co.uk/).  It's a
for pay product, but could IBM afford it?

I have used it a few years ago, and it did help me identify a data
corruption problem where SSMA did not.  They also have a comparison table
between SSMA and the two versions of MUST
(http://www.upsizing.co.uk/Pdfs/dataquerycomparison.pdf).

On their web site they also have a long list of 'how to' pages which might
also be helpful.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Friday, February 01, 2013 8:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL Server Migration Wizard

I got a day job recently.  As part of that job I am tasked with upsizing
several (or perhaps hundreds of) Access databases to SQL Server.  So I went
out to the internet and discovered the SSMA tool which has a variant
specific to Access.  While I just started playing with it all I can say is
WOW.  I tried it on a raw, unsplit database which has ODBC linked tables to
SQL Server as well as pass through queries etc.  I am just trying to see
what it does in such a case.

However I also split a database using the split wizard and then migrated
that using the SSMA and it just went.  Awsome.  Tables, indexes, PKs, etc.
I want to discover what happens with tables where there is referential
integrity established so I added that to a table pair that were in fact
related and re-migrated those two tables.  I did not check the cascade
update / delete though I will go back and do that just to see what happens.

My question is how do I see the constraint preventing deletion of parent
records when the child exists?  Where in the SSMS GUI can I visually see
that stuff?

--
John W. Colby

Reality is what refuses to go away
when you do not believe in it

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com