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 |
|
Fatalsniper
Starting Member
45 Posts |
 Posted - 2005-09-08 : 21:51:20
|
| Hi there,What's the best way/tool to migrate an Access 2000(size 500MB, over 100 tables) Database to SQL Server 7, keeping all relationships, indexes, views, and all.Thanks a lot in advance! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-08 : 22:03:31
|
| There is a built-in Upsize to SQL Server Wizard under the Tools menu in Access 2000 and later. It's dirt simple to use and understand and does an admirable job of moving everything to SQL Server. Make sure you look at each option carefully as you progress through the wizard. Also, at some point you'll be asked if you want to have the referential integrity done via DRI or triggers, you should specify DRI (or whatever term they use), NOT triggers.Keep in mind that forms, reports, macros and modules will not be upsized, as they have no corollary in SQL Server. |
 |
|
|
Fatalsniper
Starting Member
45 Posts |
Posted - 2005-09-08 : 23:04:59
|
| Thanks a lot! |
|
|
|
|
|
|
Migrate From Access 2000 to SQL Server 7