topic Re: What are the Pros / Cons of a Data Management Studio file-based repository vs. DB-based repository in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148670#M2503 <HTML><HEAD></HEAD><BODY><P>Hi Mal, this DM Studio 2.6 user guide topic . .&nbsp; .</P><P></P><P><A class="active_link" href="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_ReposAdd_sqlite.html" title="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_ReposAdd_sqlite.html">Adding a File-Based Repository for the Client </A></P><P></P><P>. . . says:</P><P></P><P>"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."</P></BODY></HTML> Fri, 12 Dec 2014 18:30:49 GMT DaveR_SAS 2014-12-12T18:30:49Z What are the Pros / Cons of a Data Management Studio file-based repository vs. DB-based repository https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148669#M2502 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 12 Dec 2014 18:09:56 GMT https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148669#M2502 mal 2014-12-12T18:09:56Z Re: What are the Pros / Cons of a Data Management Studio file-based repository vs. DB-based repository https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148670#M2503 <HTML><HEAD></HEAD><BODY><P>Hi Mal, this DM Studio 2.6 user guide topic . .&nbsp; .</P><P></P><P><A class="active_link" href="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_ReposAdd_sqlite.html" title="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_ReposAdd_sqlite.html">Adding a File-Based Repository for the Client </A></P><P></P><P>. . . says:</P><P></P><P>"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."</P></BODY></HTML> Fri, 12 Dec 2014 18:30:49 GMT https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148670#M2503 DaveR_SAS 2014-12-12T18:30:49Z Re: What are the Pros / Cons of a Data Management Studio file-based repository vs. DB-based repository https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148671#M2504 <HTML><HEAD></HEAD><BODY><P>Hi Dave,</P><P></P><P>Perfect!&nbsp; Thank you for this.</P><P></P><P>- mark</P></BODY></HTML> Fri, 12 Dec 2014 18:47:51 GMT https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148671#M2504 mal 2014-12-12T18:47:51Z Re: What are the Pros / Cons of a Data Management Studio file-based repository vs. DB-based repository https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148672#M2505 <HTML><HEAD></HEAD><BODY><P>Great! If you mark this as question as "answered" that will help. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Fri, 12 Dec 2014 19:18:46 GMT https://communities.sas.com/t5/SAS-Data-Management/What-are-the-Pros-Cons-of-a-Data-Management-Studio-file-based/m-p/148672#M2505 DaveR_SAS 2014-12-12T19:18:46Z