Mirating Queries using SSMA tool

[teja]

Hi all,

I have an access DB which has some tables and queires. While migrating the DB to SQL server 2008, the tool SSMA is migrating the tables but not the queries.

Does anyone of you have a prior experience with queries migration from Access to SQL Server 2008 using SSMA tool.

Kindly help.Thanks in advance.

 

[MSAccessRookie]

Hi all,

I have an access DB which has some tables and queires. While migrating the DB to SQL server 2008, the tool SSMA is migrating the tables but not the queries.

Does anyone of you have a prior experience with queries migration from Access to SQL Server 2008 using SSMA tool.

Kindly help.Thanks in advance.

I have only used SSMA with SQL Server 2005, but I had no issues in choosing Queries to migrate to Views. I did, have major issues with the actual Migrations, due to incompatabilities and an incomplete Migration process. In addition to the issues of parameters in Queries (which cannot be converted to Views and must be converted to Stored Procedures or Functions instead), I also found issues with certain Functions and Keywords, including (but mot limited to):

• DISTINCTROW
• IIf()
• cStr and other similar Type conversion Functions
• Date Formats
• SubQuery Format

 

[teja]

No one is expected to know everything and we can all learn from each other if we try.

This forum is about taking the next step (or perhaps the next two steps) toward becoming a better Access programmer. If a person does not need to or want to take those steps, then they do not have to. If they do, we are here to try to help them along

I faced some of the issues mentioned. I did not mean to offend. I just started working on the project so wanted to gather as much info as possible.

Thanks for the information.

 

[MSAccessRookie]

I faced some of the issues mentioned. I did not mean to offend. I just started working on the project so wanted to gather as much info as possible.

Thanks for the information.

Please to not take offense or assume offense is taken. Instead read the TAG Line to mean exactly what it says. No one can know everything, and no one really wants to know everything. We can all learn from each other if we want to. All we need to do is ask for help.

My initial response referred to the fact that I hadperformed a similar task using a previous version of SQL Server. It was for informational purposes only.

I expect to possibly learn a few things about SQL Server 2008 along the way as I watch this thread grow.