Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  I need advice on SQL database synch
Previous Previous
 
Next Next
New Post 7/1/2008 12:35 PM
User is offline delphiman
4 posts
10th Ranked


I need advice on SQL database synch 

Hi,

I have my DNN sites are running on development and production servers. All the files on development server and production server are pretty much the same. Now the development DNN site connect to a development SQL 2005 database server and production DNN site is connecting to a production SQL 2005 server.

I am trying to have my internal staff to make change on the development site first before put it to the live server. Does anybody know the best way to have the database on developent server will synch or update to the production sql database server if anytime we change from the development sql server?

Manually or automatically fine with me

Thanks
 
New Post 7/2/2008 7:19 AM
User is offline Mitch Sellers
5372 posts
www.mitchelsellers.com
3rd Ranked




Re: I need advice on SQL database synch 

You have to be very careful with this, as to actually implement it you must NEVER make changes on the other environment as your id's and other relational items can get out of sync with each other and cause total chaos.

You could most likely configure replication or another method if you truly want the dev database to be considered the actual data, but that would do it real time so most likely it will not meet your needs.

You might be able to use a DB compare tool to generate sync scripts when needed.

-Mitchel Sellers
MCITP, MCPD, MCTS
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Consulting Quotes, and DNN Technical Support Services

I reccomend 3Essentials for shared hosting and BaseCamp for project management
 
New Post 7/2/2008 8:13 AM
User is offline WEBPC
377 posts
www.webpc.biz
8th Ranked




Re: I need advice on SQL database synch 

After taking heed of Mitch's warnings have a look at the Red Gate SQL compare products (also the SQL comparison bundle).  When sync'ing the 2 databases you don't want to sync all the tables (e.g. the event and log tables). These products allow you to choose which tables and rows you want to sync. We have found them very useful.

HTH

Antony
 
New Post 7/7/2008 11:45 AM
User is offline delphiman
4 posts
10th Ranked


Re: I need advice on SQL database synch 

Thanks for your input

But I still do not understand what is the real purpose of setting the site on development server and production server if we can not synch database with each other?
 
New Post 7/8/2008 2:46 AM
User is offline lanceomagnifico
29 posts
10th Ranked


Re: I need advice on SQL database synch 

You can sort of sync them using tools - but as said above, you have to be careful!  There is not any inbuilt functionality in DNN to do this syncing for you, but you *could* use SQL server replication.
 
 Page 1 of 212Next 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  I need advice on SQL database synch
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Web Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/ 		Windsor Management Group
Fund Accounting Software for K12 Education.
Infinitevisions.com 		Convert Visitors to Customers
In order to bring value to your users, we must first understand them. VIVIDSITES will help you build a custom web application and interactive marketing tools that your users will thank you for. We marry high-end creative with head banging technology to entertain and convert visitors into paying customers. Call 314.514.0505 or visit us at http://www.vividsites.com to find out how.
- V I V I D S I T E S -

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP