The Upsizing Wizard built into Access does not bring over the "queries" in the Access database.
I surmise these are the equivalent of stored procedures. Not sure why the upsizing did not bring this over. I did find this nice add on from Microsoft which claims to migrate from Access to SQL server.
Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server or SQL Azure
http://www.microsoft.com/en-us/download/details.aspx?id=28763
http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx
No comments:
Post a Comment