[AccessD] SQL Server Migration Wizard

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

It is likely to be early days for you, but in my experience in 'CorporateLand' is that the majority of 3rd party addins are blocked by default - which I can understand otherwise they would be infested with "Ask" toolbars and other crap.  However, if you dig around you can usually ask for an exception on these things, especially for productivity tools such as MZ Tools and Search & Replace (by Rick Fisher).

I usually explain that these addin's have been around for years and are already commonly used by many other large corporates without bother or incident and save you many hours of work.

Often it is just a matter of getting some middle manager to tick it off. 

The other thing you can try - but doesn't always work, is to download the installers to a USB stick and them load them into corporate world from the USB.  I have done that plenty of times in the past too, although some places have stricter security on their USB ports than others (some places have them locked... hmmmm).

But of course, your mileage and success on this will vary between organisations.  Some are more flexible than others.  That said - it is worth a try as they are handy tools to have close.


Cheers
Darryl



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Saturday, 2 February 2013 2:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>

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