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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.