Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Database upload to production question,  thanks!!!!Database upload to production question, thanks!!!!
Previous
 
Next
New Post
12/25/2007 1:33 PM
 

Hi,

I recently learned that after uploading an asp.net website that the .mdf file can be read and written too even though it was not attached to the data base server.  When I upload the files for a DNN 4.07 website to the production server how can this behavior be modified.  When I use the SQL upload wizard and make a .sql file,  then run the script on the production server it install fine,  no errors.  But the website still updates the .mdf in the app_data folder.  Not the MDF I created with the script that is attached to the database engine.  How would this mess up managing my DNN website's DATABASE  when I upload it?  I'm not a DBA so I'm clueless,  yet it's Christmas day and here I am trying to get this working.  Perhaps it's a different web.config connection string that will do it?  The XP machine and the Windows2003 both are running SQL2005 express.

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DNN12_24_07.mdf;" providerName="System.Data.SqlClient" />

Any pointers would be much appreciated.

Thanks

-KK

 
New Post
12/25/2007 3:10 PM
 

Hi again,

In the connection string where it has "   AttachDBFilename=|DataDirectory|DNN12_24_07.mdf   "  Is that how the database is attached and runs with out me manually attaching it?  Does this only work this way in SQL2005 Express?

 

Thanks again

KK

 

 
New Post
12/25/2007 6:50 PM
 

What I would do is, quit messing with the script and just make a .bak of the site restore it to the production environment from that file.  That is going to be the most reliable way of backing up and restoring.  Just make sure that you zip the site up as well when you backup the database.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Database upload to production question,  thanks!!!!Database upload to production question, thanks!!!!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out