Best way to migrate 18 access applications to SQL server

[johanboerema]

Hi,

I have 18 Access applications, that all look at the same database. I would like to migrate my database to SQL Server, and let my queries look at that SQL server database, so no SQL views etc.
I would also like to create new queries just like I always did in my Access environment, but they need to look at the SQL server also.

What is the best way to accomplish this?

Best regards,

Johan Boerema

 

[SGT68]

Hi,

I have 18 Access applications, that all look at the same database. I would like to migrate my database to SQL Server, and let my queries look at that SQL server database, so no SQL views etc.
I would also like to create new queries just like I always did in my Access environment, but they need to look at the SQL server also.

What is the best way to accomplish this?

Best regards,

Johan Boerema

this seems to work:

http://www.microsoft.com/en-gb/download/details.aspx?id=42656

 

[johanboerema]

Thank you!
Do you know if it's possible to rename the views SSMA makes of the queries?
I would like to have application_ before all views, so I can see from which application which view is.

Best regards,

Johan Boerena

 

[SGT68]

Thank you!
Do you know if it's possible to rename the views SSMA makes of the queries?
I would like to have application_ before all views, so I can see from which application which view is.

Best regards,

Johan Boerena

Sorry i don't know, i havent used it that much

 

[johanboerema]

Maybe, if I can't rename them, I will change to names of the queries before I migrate it. But is it then possible to create a function in Access that always prefixes the query? So I don't have to rename all the queries through all the applications?
Or maybe another smart method?