XCopy deployment of MDF files with ODBC

Friday, 25 November 2005

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:\zope261\3.03.05\DW30305DEMO.mdf
2. Win+Run odbccp32.cpl
3. Assign default database name and database filename to the same one as in step 1 (see picture)

The entry 'XCopy deployment of MDF files with ODBC' was posted on November 25th, 2005 at 12:33 am and last modified on November 25th, 2005 at 12:43 am, and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.