Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBGhost Expand / Collapse
Author
Message
Posted Friday, October 14, 2005 3:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 22, 2009 2:50 PM
Points: 28, Visits: 53

My company is currently in the process of becomgin SOX compliant. We are setting up a development,test,and production server environment. I have downloaded the evaluation version of DBGhost but am not sure exactly where to start. Do you have to be using a version control program to use DBGhost. Any help would be appreciated.

Thank You

Post #229156
Posted Monday, October 17, 2005 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #229340
Posted Tuesday, January 3, 2006 10:25 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 8:34 AM
Points: 108, Visits: 6

Hi Robert,

if you have any specific questions I can help or you can use the specialist forum: http://dbghost.forumco.com/forum~FORUM_ID~7.asp

 

 


regards,
Mark Baekdal

MSN m_baekdal@hotmail.com

+44 (0)208 241 1762
http://www.dbghost.com

http://www.innovartis.co.uk

Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

 

 

 

Post #247979
Posted Tuesday, March 7, 2006 9:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:49 PM
Points: 331, Visits: 553
What were your results with testing DBGhost?  Did you like the product?  We're looking at solutions too....


Post #263902
Posted Tuesday, March 7, 2006 2:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 22, 2009 2:50 PM
Points: 28, Visits: 53
The evaluation period for DGGhost was not very long and we did not get a chance to evaluate the product thoroughly.  We did end up purchasing another package by Red Gate software that included SQL Data Compare, SQL Compare as well as a few other programs. We are very happy with it.
Post #263982
Posted Tuesday, March 7, 2006 2:41 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:49 PM
Points: 331, Visits: 553
How does SQL Data Compare work?  Does it use triggers, add tables to the databases, read transaction logs, use trace procedures....  I'm concerned with performance and not adding anything to databases.


Post #263983
Posted Tuesday, March 7, 2006 3:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 22, 2009 2:50 PM
Points: 28, Visits: 53

We are using the SQL Data Compare and the SQL Compare to keep our development and our production databases synchronized.

The SQL Data Compare looks at tables that you specify and compares the data in each table and allows you to move data one way or the other.

The SQL Compare will compare tables,stored procedures and other db objects and show the differences between the two. The program will create a script that you can either run in the SQL Compare program or copy into query analyzer and run.

 

Post #263990
Posted Tuesday, October 24, 2006 3:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 2:37 AM
Points: 1, Visits: 37

Hello,

We currently use DBGhost to achieve Canadian Bill198 compliance (SOX derivitive). DBGhost scripts off database objects with the exception of DTS (which we use redgate DTS compare) to Visual Source Safe, developers are setup in source safe to check in and out of source safe. DbGhost then looks at source safe and synchronises with the target server, producing a report on the changes made. Simple.

U can also use it for data and schema comparisons btween db's ondifferent servers (say development and qa or qa and production) and then it allows you to synchronise should you wish to.

RedGate cannot integrate with source safe therefore for sox compliance there is no safe source for SQL code control. You would need to tie down the sql server so much that no one has access to it.

We only allow DBA access to production and developers to development. Developers promote to QA with DBGhost but only dba's will promote from QA to production so that segregation of duty issues are complied with....but thats a whole new ball game !!

Cheers

Post #317730
Posted Saturday, January 27, 2007 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 2, 2007 6:59 AM
Points: 5, Visits: 2
The Redgate stuff and DBGhost are developers tools and should not be used for auditing, you should either use SQL Watch from Quest.com or Lumigent Entegra. Depending on the level you need to go to.
Post #340303
Posted Saturday, January 27, 2007 11:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:05 PM
Points: 1,190, Visits: 601

 

I agree with Declan For SOX you have to use auditing products...

We are using Lumigent Entegra... It is not that good but all are these products are new so it will take some time to get the good one out...

 



MohammedU
Microsoft SQL Server MVP
Post #340319
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse