Watch this Ask the Expert session to learn best practices to efficiently migrate from one database management system to another.
Watch the webinar
Join Rex Pruitt as he discusses the considerations you need to address before taking on a database migration. Watch this webinar to learn:
- Why the approach to where data should be processed is important.
- Hardware, software and data considerations when migrating to a new database management system.
- Why “collaboration” is key to success.
The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached.
How can I get hands-on help doing a migration in my environment?
There are workshops available through SAS. We have a data workshops on data access/connectivity. We also have administration, visualization, and advanced analytics workshops. Please follow up with your Account team for details.
If I want to find out more, what are the recommended resources?
The SAS Communities Library is a great place to visit. You can also post questions and read other user’s comments in the Administration and Deployment and Architecture Communities. All the resources shared during the webinar are linked in the slide deck attached to this post.
With LIBNAME, getting database schema, is the full schema data transferred to the SAS server?
The tables are not transferred. Only the metadata is passed to the SAS server. The "Best Practice" is to always limit the amount data that is brought back. If you are using a SAS User Interface (UI) like Enterprise Guide, it is advised that you adjust the settings to restrict the data that is returned to the SAS Server by default (e.g., Tool Bar: Tools>Options>Data>Performance…[adjust any setting that could impact performance]). In the SAS UI, DO NOT double-click on the tables listed in the File Explorer (or, Servers>Libraries>…) window. Doing so will submit a query to the DBMS and could freeze your SAS UI session if there is even one 32,767 byte column. Instead, use the right-click>Properties method of viewing the table metadata to ensure there are no columns with the 32,767 byte columns that may plug up the SAS UI memory buffer.
Recommended Resources
Best Practice Considerations for Database Management System (DBMS) Migration
An Insider’s Guide to SAS and Database Support Information
SAS/ACCESS Documentation
SAS with Hadoop Paper
Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from other SAS Ask the Expert webinars.
