How To Perform Database Migration Assessment Using SSMA Console Application

re: How To Perform Database Migration Assessment Using SSMA Console Application

Keshav Ramarao — Wed, 16 Feb 2011 18:57:36 GMT

@vj: What is the full build number of SSMA Access? Can you please send a mail to ssmahelp@microsoft.com with SSMA log file, somebody from Microsoft support team will work with you to resolve this issue.

re: How To Perform Database Migration Assessment Using SSMA Console Application

vj — Tue, 15 Feb 2011 02:45:47 GMT

hi! SSMA team,

I am trying to use ssma console for access. but while trying to connect to target sql server i am getting this error

Inner Exception #1: Object reference not set to an instance of an object.

can you please help me on resolving this issue

thanks

re: How To Perform Database Migration Assessment Using SSMA Console Application

ssma — Mon, 10 Jan 2011 23:28:13 GMT

@Vishal: You can use the UI version of the SSMA tool to see the assessment report in richer form.

re: How To Perform Database Migration Assessment Using SSMA Console Application

Vishal Soni — Fri, 03 Dec 2010 06:22:46 GMT

The reports generated as output in in XML format.

Do we have any tool / method to view these reports in simpler format that can be analyzed easily?

re: How To Perform Database Migration Assessment Using SSMA Console Application

ssma — Wed, 20 Oct 2010 00:21:50 GMT

Hello Yanqing,

Apologies for the delayed response.

Yes, you have to use the SSMA UI for modifying the default type mapping. The changes are stored in environment files of the project under "C:\Users\<user>\AppData\Roaming\Microsoft SQL Server Migration Assistant\?2ss-2008". You can use this "custom" environment for your console project. While running SSMA console application you can specify the "custom" environment using "-e" switch with the folder path containing the environment files. Projects created or opened using console uses the "custom" type mapping that you have specified.

If you need technical help feel free to write to us at ssmahelp@microsoft.com, we offer free support for SSMA tools.

Thanks!

SSMA Team

re: How To Perform Database Migration Assessment Using SSMA Console Application

Yanqing lin — Tue, 19 Oct 2010 20:50:25 GMT

Hi SSMA team,

Could you please the last comment?

Thanks

re: How To Perform Database Migration Assessment Using SSMA Console Application

Yanqing Lin — Sun, 17 Oct 2010 23:37:08 GMT

Hi there,

How can I change the data type mappings in the script? Do I have to do it from SSMA UI interface?

Thanks

Yanqing