XCopy deployment of MDF files with ODBC

Deployment notes: Deploying an MDF file to an installation using SQL Server Express 2005 or SQL Server 2005. (The following is useful if you require ODBC)

  1. Note down the path to the MDF file, e.g. C:zope2613.03.05DW30305DEMO.mdf
  2. Win+Run odbccp32.cpl
  3. Assign default database name and database filename to the same one as in step 1 (see picture)

ODBC and SQL Server Express


About this entry