YAFLogo

rlrhett
  • rlrhett
  • 53% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
I want to integrate my existing web application with the YAF. I have some preliminary questions I would like to clarify and could not find the answers in the FAQ's and tutorials:

1) My existing web app already has databases within an instance of SQL (let's call it "SERVER\SQL2008"). Do I need to start a second instance for YAF, or does YAF build a database in addition to my existing databases?

The instructions are to create a new instance and blank db, but I just don't know if that assumes you don't already have one or whether you need separate instances.I have set up a separate instance of SQL (let's call it "SERVER\SQLEXPRESS") and created a YAF db there. I can get the YAF source code to compile and run no problem from VB2008 as a stand alone solution. However, I want to integrate it into my existing solution.

2) Obviously, my web.config file already has a connection string for my existing web app and an existing default db. I don't see anywhere that discusses what to do if your existing web.config file already has a connection string and default db. It all seems to assume you are creating an instance and db for the first time. Do I simply add a second connection string to the YAF db, or will that create a conflict?

Thanks,


Randolph Rhett

MyTimeFinder, the first

Intelligent Online Time Management Software 

Sponsor
rlrhett
  • rlrhett
  • 53% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
Well, I'm going for a bump. I can't believe that no one knows. Can YAF be installed into an existing instance of SQL, and if so how do I initialize web.config so it does not conflict with the existing configuration string for my web application? Anyone?

Thanks!


Randolph Rhett

MyTimeFinder, the first

Intelligent Online Time Management Software 

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA
14 years ago

Well, I'm going for a bump. I can't believe that no one knows. Can YAF be installed into an existing instance of SQL, and if so how do I initialize web.config so it does not conflict with the existing configuration string for my web application? Anyone?

Thanks!

Originally Posted by: rlrhett 

You can use the existing connection string and the same db.

There is a App.config setting for the DB that adds a prefix to all of the db stuff (Tables, Procedures, etc.), that makes sure there will no conflicts with your existing db.

<!--
  ******************************************************************
	** databaseObjectQualifier Key ** Defaults to: yaf_ **
  
  For advanced users who want to change the prefix for Yaf DB
  structure.
  -->
  <add key="YAF.DatabaseObjectQualifier" value="yaf_" />