[AccessD] SQL Server Migration Wizard

The first problem I run into is "Is it on IBM's list of approved vendors?"

Most small guys are not.  Just as an example I went to RickFisher's web site... blocked by the browser.

Microsoft definitely is approved and SSMA is not blocked so I just downloaded it and ran.

My question of course is on the SQL Server side, via SSMS, how do I see information about the 
relationships.  I managed to get the Database Diagrams pane to show and sure enough, the existing 
relationships between the two tables is displayed as soon as I drag them out on thhe diagram.

GOOD NEWS!

John W. Colby

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

On 2/1/2013 10:17 AM, Dan Waters wrote:
> 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
>