Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBGhost


DBGhost

Author
Message
Robert Wilson-203725
Robert Wilson-203725
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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


mark baekdal-145375
mark baekdal-145375
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 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


Linda Johanning
Linda Johanning
Old Hand
Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)

Group: General Forum Members
Points: 367 Visits: 621
What were your results with testing DBGhost? Did you like the product? We're looking at solutions too....



Robert Wilson-203725
Robert Wilson-203725
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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.
Linda Johanning
Linda Johanning
Old Hand
Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)

Group: General Forum Members
Points: 367 Visits: 621
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.



Robert Wilson-203725
Robert Wilson-203725
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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.


karlmcauley
karlmcauley
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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


Declan McGrory
Declan McGrory
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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.
MohammedU
MohammedU
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1298 Visits: 812

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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search