Access to SQL Server conversion

• s-sql

  SSCommitted

  Points: 1970

  More actions

  December 14, 2011 at 8:40 am

  #100792

  My client has a requirement to migrate from Access back end database to SQL server express.

  There are few reports and forms, and want to retain them.

  The report front end has date fields(from and to dates) and a region selection drop down.

  Once the data is migrated to SQL server, they want to fetch the data by passing the values from access front end to SQL server.

  I am a novice on Access, and What approach should be followed to acheive this.

  1. Should I use SSMA, to migrate database to SQL and link tables.

  2. In that case, how does the existing queries pass the selected values on access front to SQL Server.

  Would there any improvement on Query performance, specially when the data grows beyond 2 GB.

  3. Can the SQL server database reside on Server A and have the access front end on Client Machine.

  I am assuming, the connection could be established through ODBC.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  December 14, 2011 at 8:49 am

  #1421379

  These items might assist you in deciding on the migration

  http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

  http://office.microsoft.com/en-us/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspx

  http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]