Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NHS
Starting Member
8 Posts |
 Posted - 2005-11-08 : 18:29:50
|
| Hi GuysI have a patient-information database in Access, at the moment, it doesnt exceed 2GB, however, we will be importing a couple million patient records, what is the best way to upsize the database to a backend SQL Server?Is there a guide i can use that anyone knows of?Any help is appreciated.Phil |
|
|
mcordewener
Starting Member
19 Posts |
Posted - 2005-11-09 : 04:05:10
|
| Hi,MS Access has a standard functionality called upsizing. This program puts your Access DB into a SQL Server instance. The Access program will be converted to an Access project. This tool can also be downloaded at the MS website.http://www.microsoft.com/downloads/results.aspx?displaylang=en&freeText=upsizeBe alert. This upzising wizard does not convert MS Access functions completely to SQL server you need to check these.Greetz,Marcel |
 |
|
|
|
|
|
Upsizing Access DB