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 |
|
JanZ
Starting Member
2 Posts |
 Posted - 2008-01-21 : 19:51:55
|
| I’ve been asked to migrate many Access databases to SQL Server. There are no reports, queries or forms in these databases. There are two different database structures. Each has many copies with different data. For example, 80 people each have a copy of abc.mdb. Each copy has the same tables, but different data. The databases cannot be merged without modifying the structure of the databases and the programs that access them. There are over 100 databases ranging in size from 2 MB to 60 MB.What’s the best approach to do this? I don’t want to manually run each through the upsize wizard.Should I use a local SQL Server Express or a central SQL Server?Will there be any benefits to doing this? Will the performance improve?Personally I’d rather redesign the databases, merge the data and modify the applications that use the data. But it’s not my decision. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 19:55:48
|
| At least put them on single sql server. |
 |
|
|
JanZ
Starting Member
2 Posts |
Posted - 2008-01-22 : 18:05:05
|
| Thanks for responding. |
|
|
|
|
|
|
Migrate multiple Access databases