Are there any advantages to setting up Data Management Studio to use a File-based repository, vs. a DB-based repository? Is either one faster? Is either one more reliable?
Thanks!
Hi Mal, this DM Studio 2.6 user guide topic . . .
Adding a File-Based Repository for the Client
. . . says:
"DataFlux Data Management Studio and DataFlux Data Management Server are installed with repositories that use an SQLite file for the repository database. File-based repositories are simple and reliable. They do not require a DBMS connection, and they might suffice for testing and training. File-based repositories are not recommended for multi-user access, however, due to locking issues. Sites typically create DBMS-based repositories for production systems."
Hi Mal, this DM Studio 2.6 user guide topic . . .
Adding a File-Based Repository for the Client
. . . says:
"DataFlux Data Management Studio and DataFlux Data Management Server are installed with repositories that use an SQLite file for the repository database. File-based repositories are simple and reliable. They do not require a DBMS connection, and they might suffice for testing and training. File-based repositories are not recommended for multi-user access, however, due to locking issues. Sites typically create DBMS-based repositories for production systems."
Hi Dave,
Perfect! Thank you for this.
- mark
Great! If you mark this as question as "answered" that will help.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.