1 / 25

GTS DB Conversion

Transitioning from MS Access to MS SQL Server can be straightforward, especially with a solid plan. Our process utilized MS Access 2007, addressed VB issues, and transferred data structures seamlessly to the server. We enhanced performance with strategic indexing and optimized user security. Facing hurdles, we aimed to design a user-friendly interface that changes how users interact with their data. While the Access wizard simplifies initial setups, we focused on creating a robust system adaptable to user needs and large data sets, ensuring a smooth migration experience.

kineks
Télécharger la présentation

GTS DB Conversion

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GTS DB Conversion Going from MS Access to MS SQL Server can be simple… if you let it be.

  2. What we did… • Used MS Access 2007 • Fixed VB Issues with Access 2007+ • Copied Structures and Data up to the Server • Added a couple of Indexes on frequently used fields • Setup User Security

  3. Hurdles we faced… • Leaving design open for a more Optimal UI to be designed • Change the way Users think about “searching” through their data • Change control?

  4. Why MS Access 2007? Reasons…: • The Wizard makes it easy, especially compared to prior versions of MS Access. • The Wizard makes it easy. • Seriously… you need another reason?

  5. Why not MS Access 2007? There are reasons not to use the Wizard… or to use it differently. • You can design from the Ground up… then push data(i.e.: No more complaints about prior developers). • You can just push the structures, then tweak it.(Useful for particularly large sets of data and data file management)

  6. VB Issues with Access 2007 It could happen to you…

  7. VB Issues with Access 2007 Luckily for us, it’s easy to fix.

  8. VB Issues with Access 2007

  9. VB Issues with Access 2007

  10. VB Issues with Access 2007

  11. VB Issues with Access 2007

  12. VB Issues with Access 2007

  13. Copy Structures and Data to the Server “…if ever a Wiz there was! ...”

  14. Copy Structures and Data to the Server

  15. Copy Structures and Data to the Server

  16. Copy Structures and Data to the Server

  17. Copy Structures and Data to the Server

  18. Copy Structures and Data to the Server

  19. Copy Structures and Data to the Server

  20. Copy Structures and Data to the Server

  21. Added a couple of Indexes CREATE NONCLUSTERED INDEX [PI_LName] ON [dbo].[tblPI] ( [PI] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF…

  22. Setup User Security

  23. Setup User Security

  24. Setup User Security

  25. Questions?Comments?Concerns?

More Related