Internally we utilize Red-Gates SQL Compare tool to make sure that the
internal development and production database are in sync with the
appropriate source code. However, I have a live production versions at X
client sites and at the client site what would be the best way to see there
data structures? Script it and then rebuilt it at our office? Or, is there
a was to make a "snapshot" of the remote database? The snapshot is
something that is part of the Red-Gate tool but I am sure it's in SQL
Enterprise manager too, I just don't know what it's called in there.
Every week I learn new tricks from all you SQL junkies - thank you in
advance!
Chris
Chris Marsh wrote:
> Internally we utilize Red-Gates SQL Compare tool to make sure that the
> internal development and production database are in sync with the
> appropriate source code. However, I have a live production versions
> at X client sites and at the client site what would be the best way
> to see there data structures? Script it and then rebuilt it at our
> office? Or, is there a was to make a "snapshot" of the remote
> database? The snapshot is something that is part of the Red-Gate
> tool but I am sure it's in SQL Enterprise manager too, I just don't
> know what it's called in there.
> Every week I learn new tricks from all you SQL junkies - thank you in
> advance!
> Chris
You can script out a database from SQL Enterprise Manager from the
Database - All Tasks - Generate SQL Script option. Before using SQL
Compare to do the same at the customer site, make sure the license
agreement you have for the software allows for it's use on servers not
owned/leased by your company.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||I thought about that too; so when I script the client's database and then
pull it locally I will need to attach it to my SQL Server for the SQL
Compare tool. Red-Gate's tool is licensed (from what I understand in
speaking with them) properly as long as we don't install it at the client
site, it needs to stay on our development / support machines. Hence my
questions...
Thank you!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23sNVPL8hFHA.720@.TK2MSFTNGP14.phx.gbl...
> Chris Marsh wrote:
> You can script out a database from SQL Enterprise Manager from the
> Database - All Tasks - Generate SQL Script option. Before using SQL
> Compare to do the same at the customer site, make sure the license
> agreement you have for the software allows for it's use on servers not
> owned/leased by your company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Chris Marsh wrote:
> I thought about that too; so when I script the client's database and
> then pull it locally I will need to attach it to my SQL Server for
> the SQL Compare tool. Red-Gate's tool is licensed (from what I
> understand in speaking with them) properly as long as we don't
> install it at the client site, it needs to stay on our development /
> support machines. Hence my questions...
> Thank you!
Scripting a database just produces a big script file of the DDL
operations required to re-create the database somewhere else. You'll
need to script the client's db, create a new database locally, run the
script, then use SQL Compare to compare database schemas.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Again, I appreciate your assistance!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:e7Gxrv8hFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Chris Marsh wrote:
>
> Scripting a database just produces a big script file of the DDL operations
> required to re-create the database somewhere else. You'll need to script
> the client's db, create a new database locally, run the script, then use
> SQL Compare to compare database schemas.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
Showing posts with label production. Show all posts
Showing posts with label production. Show all posts
Thursday, March 22, 2012
comparing database's
Internally we utilize Red-Gates SQL Compare tool to make sure that the
internal development and production database are in sync with the
appropriate source code. However, I have a live production versions at X
client sites and at the client site what would be the best way to see there
data structures? Script it and then rebuilt it at our office? Or, is there
a was to make a "snapshot" of the remote database? The snapshot is
something that is part of the Red-Gate tool but I am sure it's in SQL
Enterprise manager too, I just don't know what it's called in there.
Every week I learn new tricks from all you SQL junkies - thank you in
advance!
ChrisChris Marsh wrote:
> Internally we utilize Red-Gates SQL Compare tool to make sure that the
> internal development and production database are in sync with the
> appropriate source code. However, I have a live production versions
> at X client sites and at the client site what would be the best way
> to see there data structures? Script it and then rebuilt it at our
> office? Or, is there a was to make a "snapshot" of the remote
> database? The snapshot is something that is part of the Red-Gate
> tool but I am sure it's in SQL Enterprise manager too, I just don't
> know what it's called in there.
> Every week I learn new tricks from all you SQL junkies - thank you in
> advance!
> Chris
You can script out a database from SQL Enterprise Manager from the
Database - All Tasks - Generate SQL Script option. Before using SQL
Compare to do the same at the customer site, make sure the license
agreement you have for the software allows for it's use on servers not
owned/leased by your company.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I thought about that too; so when I script the client's database and then
pull it locally I will need to attach it to my SQL Server for the SQL
Compare tool. Red-Gate's tool is licensed (from what I understand in
speaking with them) properly as long as we don't install it at the client
site, it needs to stay on our development / support machines. Hence my
questions...
Thank you!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23sNVPL8hFHA.720@.TK2MSFTNGP14.phx.gbl...
> Chris Marsh wrote:
>> Internally we utilize Red-Gates SQL Compare tool to make sure that the
>> internal development and production database are in sync with the
>> appropriate source code. However, I have a live production versions
>> at X client sites and at the client site what would be the best way
>> to see there data structures? Script it and then rebuilt it at our
>> office? Or, is there a was to make a "snapshot" of the remote
>> database? The snapshot is something that is part of the Red-Gate
>> tool but I am sure it's in SQL Enterprise manager too, I just don't
>> know what it's called in there.
>> Every week I learn new tricks from all you SQL junkies - thank you in
>> advance!
>> Chris
> You can script out a database from SQL Enterprise Manager from the
> Database - All Tasks - Generate SQL Script option. Before using SQL
> Compare to do the same at the customer site, make sure the license
> agreement you have for the software allows for it's use on servers not
> owned/leased by your company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Chris Marsh wrote:
> I thought about that too; so when I script the client's database and
> then pull it locally I will need to attach it to my SQL Server for
> the SQL Compare tool. Red-Gate's tool is licensed (from what I
> understand in speaking with them) properly as long as we don't
> install it at the client site, it needs to stay on our development /
> support machines. Hence my questions...
> Thank you!
Scripting a database just produces a big script file of the DDL
operations required to re-create the database somewhere else. You'll
need to script the client's db, create a new database locally, run the
script, then use SQL Compare to compare database schemas.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Again, I appreciate your assistance!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:e7Gxrv8hFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Chris Marsh wrote:
>> I thought about that too; so when I script the client's database and
>> then pull it locally I will need to attach it to my SQL Server for
>> the SQL Compare tool. Red-Gate's tool is licensed (from what I
>> understand in speaking with them) properly as long as we don't
>> install it at the client site, it needs to stay on our development /
>> support machines. Hence my questions...
>> Thank you!
>
> Scripting a database just produces a big script file of the DDL operations
> required to re-create the database somewhere else. You'll need to script
> the client's db, create a new database locally, run the script, then use
> SQL Compare to compare database schemas.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
internal development and production database are in sync with the
appropriate source code. However, I have a live production versions at X
client sites and at the client site what would be the best way to see there
data structures? Script it and then rebuilt it at our office? Or, is there
a was to make a "snapshot" of the remote database? The snapshot is
something that is part of the Red-Gate tool but I am sure it's in SQL
Enterprise manager too, I just don't know what it's called in there.
Every week I learn new tricks from all you SQL junkies - thank you in
advance!
ChrisChris Marsh wrote:
> Internally we utilize Red-Gates SQL Compare tool to make sure that the
> internal development and production database are in sync with the
> appropriate source code. However, I have a live production versions
> at X client sites and at the client site what would be the best way
> to see there data structures? Script it and then rebuilt it at our
> office? Or, is there a was to make a "snapshot" of the remote
> database? The snapshot is something that is part of the Red-Gate
> tool but I am sure it's in SQL Enterprise manager too, I just don't
> know what it's called in there.
> Every week I learn new tricks from all you SQL junkies - thank you in
> advance!
> Chris
You can script out a database from SQL Enterprise Manager from the
Database - All Tasks - Generate SQL Script option. Before using SQL
Compare to do the same at the customer site, make sure the license
agreement you have for the software allows for it's use on servers not
owned/leased by your company.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I thought about that too; so when I script the client's database and then
pull it locally I will need to attach it to my SQL Server for the SQL
Compare tool. Red-Gate's tool is licensed (from what I understand in
speaking with them) properly as long as we don't install it at the client
site, it needs to stay on our development / support machines. Hence my
questions...
Thank you!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23sNVPL8hFHA.720@.TK2MSFTNGP14.phx.gbl...
> Chris Marsh wrote:
>> Internally we utilize Red-Gates SQL Compare tool to make sure that the
>> internal development and production database are in sync with the
>> appropriate source code. However, I have a live production versions
>> at X client sites and at the client site what would be the best way
>> to see there data structures? Script it and then rebuilt it at our
>> office? Or, is there a was to make a "snapshot" of the remote
>> database? The snapshot is something that is part of the Red-Gate
>> tool but I am sure it's in SQL Enterprise manager too, I just don't
>> know what it's called in there.
>> Every week I learn new tricks from all you SQL junkies - thank you in
>> advance!
>> Chris
> You can script out a database from SQL Enterprise Manager from the
> Database - All Tasks - Generate SQL Script option. Before using SQL
> Compare to do the same at the customer site, make sure the license
> agreement you have for the software allows for it's use on servers not
> owned/leased by your company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Chris Marsh wrote:
> I thought about that too; so when I script the client's database and
> then pull it locally I will need to attach it to my SQL Server for
> the SQL Compare tool. Red-Gate's tool is licensed (from what I
> understand in speaking with them) properly as long as we don't
> install it at the client site, it needs to stay on our development /
> support machines. Hence my questions...
> Thank you!
Scripting a database just produces a big script file of the DDL
operations required to re-create the database somewhere else. You'll
need to script the client's db, create a new database locally, run the
script, then use SQL Compare to compare database schemas.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Again, I appreciate your assistance!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:e7Gxrv8hFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Chris Marsh wrote:
>> I thought about that too; so when I script the client's database and
>> then pull it locally I will need to attach it to my SQL Server for
>> the SQL Compare tool. Red-Gate's tool is licensed (from what I
>> understand in speaking with them) properly as long as we don't
>> install it at the client site, it needs to stay on our development /
>> support machines. Hence my questions...
>> Thank you!
>
> Scripting a database just produces a big script file of the DDL operations
> required to re-create the database somewhere else. You'll need to script
> the client's db, create a new database locally, run the script, then use
> SQL Compare to compare database schemas.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
comparing database's
Internally we utilize Red-Gates SQL Compare tool to make sure that the
internal development and production database are in sync with the
appropriate source code. However, I have a live production versions at X
client sites and at the client site what would be the best way to see there
data structures? Script it and then rebuilt it at our office? Or, is there
a was to make a "snapshot" of the remote database? The snapshot is
something that is part of the Red-Gate tool but I am sure it's in SQL
Enterprise manager too, I just don't know what it's called in there.
Every week I learn new tricks from all you SQL junkies - thank you in
advance!
ChrisChris Marsh wrote:
> Internally we utilize Red-Gates SQL Compare tool to make sure that the
> internal development and production database are in sync with the
> appropriate source code. However, I have a live production versions
> at X client sites and at the client site what would be the best way
> to see there data structures? Script it and then rebuilt it at our
> office? Or, is there a was to make a "snapshot" of the remote
> database? The snapshot is something that is part of the Red-Gate
> tool but I am sure it's in SQL Enterprise manager too, I just don't
> know what it's called in there.
> Every week I learn new tricks from all you SQL junkies - thank you in
> advance!
> Chris
You can script out a database from SQL Enterprise Manager from the
Database - All Tasks - Generate SQL Script option. Before using SQL
Compare to do the same at the customer site, make sure the license
agreement you have for the software allows for it's use on servers not
owned/leased by your company.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I thought about that too; so when I script the client's database and then
pull it locally I will need to attach it to my SQL Server for the SQL
Compare tool. Red-Gate's tool is licensed (from what I understand in
speaking with them) properly as long as we don't install it at the client
site, it needs to stay on our development / support machines. Hence my
questions...
Thank you!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23sNVPL8hFHA.720@.TK2MSFTNGP14.phx.gbl...
> Chris Marsh wrote:
> You can script out a database from SQL Enterprise Manager from the
> Database - All Tasks - Generate SQL Script option. Before using SQL
> Compare to do the same at the customer site, make sure the license
> agreement you have for the software allows for it's use on servers not
> owned/leased by your company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Chris Marsh wrote:
> I thought about that too; so when I script the client's database and
> then pull it locally I will need to attach it to my SQL Server for
> the SQL Compare tool. Red-Gate's tool is licensed (from what I
> understand in speaking with them) properly as long as we don't
> install it at the client site, it needs to stay on our development /
> support machines. Hence my questions...
> Thank you!
Scripting a database just produces a big script file of the DDL
operations required to re-create the database somewhere else. You'll
need to script the client's db, create a new database locally, run the
script, then use SQL Compare to compare database schemas.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Again, I appreciate your assistance!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:e7Gxrv8hFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Chris Marsh wrote:
>
> Scripting a database just produces a big script file of the DDL operations
> required to re-create the database somewhere else. You'll need to script
> the client's db, create a new database locally, run the script, then use
> SQL Compare to compare database schemas.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
internal development and production database are in sync with the
appropriate source code. However, I have a live production versions at X
client sites and at the client site what would be the best way to see there
data structures? Script it and then rebuilt it at our office? Or, is there
a was to make a "snapshot" of the remote database? The snapshot is
something that is part of the Red-Gate tool but I am sure it's in SQL
Enterprise manager too, I just don't know what it's called in there.
Every week I learn new tricks from all you SQL junkies - thank you in
advance!
ChrisChris Marsh wrote:
> Internally we utilize Red-Gates SQL Compare tool to make sure that the
> internal development and production database are in sync with the
> appropriate source code. However, I have a live production versions
> at X client sites and at the client site what would be the best way
> to see there data structures? Script it and then rebuilt it at our
> office? Or, is there a was to make a "snapshot" of the remote
> database? The snapshot is something that is part of the Red-Gate
> tool but I am sure it's in SQL Enterprise manager too, I just don't
> know what it's called in there.
> Every week I learn new tricks from all you SQL junkies - thank you in
> advance!
> Chris
You can script out a database from SQL Enterprise Manager from the
Database - All Tasks - Generate SQL Script option. Before using SQL
Compare to do the same at the customer site, make sure the license
agreement you have for the software allows for it's use on servers not
owned/leased by your company.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I thought about that too; so when I script the client's database and then
pull it locally I will need to attach it to my SQL Server for the SQL
Compare tool. Red-Gate's tool is licensed (from what I understand in
speaking with them) properly as long as we don't install it at the client
site, it needs to stay on our development / support machines. Hence my
questions...
Thank you!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23sNVPL8hFHA.720@.TK2MSFTNGP14.phx.gbl...
> Chris Marsh wrote:
> You can script out a database from SQL Enterprise Manager from the
> Database - All Tasks - Generate SQL Script option. Before using SQL
> Compare to do the same at the customer site, make sure the license
> agreement you have for the software allows for it's use on servers not
> owned/leased by your company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Chris Marsh wrote:
> I thought about that too; so when I script the client's database and
> then pull it locally I will need to attach it to my SQL Server for
> the SQL Compare tool. Red-Gate's tool is licensed (from what I
> understand in speaking with them) properly as long as we don't
> install it at the client site, it needs to stay on our development /
> support machines. Hence my questions...
> Thank you!
Scripting a database just produces a big script file of the DDL
operations required to re-create the database somewhere else. You'll
need to script the client's db, create a new database locally, run the
script, then use SQL Compare to compare database schemas.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Again, I appreciate your assistance!
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:e7Gxrv8hFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Chris Marsh wrote:
>
> Scripting a database just produces a big script file of the DDL operations
> required to re-create the database somewhere else. You'll need to script
> the client's db, create a new database locally, run the script, then use
> SQL Compare to compare database schemas.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
Comparing data across two databases
Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
([url]http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx[/u
rl])
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in differe
nt
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.sqlsql
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
([url]http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx[/u
rl])
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in differe
nt
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.sqlsql
Comparing data across two databases
Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.
Comparing data across two databases
Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.
Monday, March 19, 2012
Compare tables layout in dev and prod
Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-Chen
Hi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen
|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-Chen
Hi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen
|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>
Compare tables layout in dev and prod
Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> > Hi,
> >
> > Does anyone know that without the tool, how to compare table's layout
> > those
> > are existing development and production servers?
> >
> > Regards,
> > -Chen
>
>
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> > Hi,
> >
> > Does anyone know that without the tool, how to compare table's layout
> > those
> > are existing development and production servers?
> >
> > Regards,
> > -Chen
>
>
Compare tables layout in dev and prod
Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a tab
le
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a tab
le
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>
Thursday, February 16, 2012
Commercial Audit Software
I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solutio
n.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible fr
om
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solutio
n.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible fr
om
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>
Commercial Audit Software
I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
Thanks
Lumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>
|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
Thanks
Lumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>
|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
Commercial Audit Software
I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>> I'm looking for a good commercial, 3rd party solution, not a Trace
>> solution.
>> Can anyone provide comments on something they have in production? So
>> far, my limited research has turned up Lumigent Entegra, and RippleTech
>> LogCaster.
>> My goal is to track DML changes by login with minimal impact on system
>> performance. Further, I need the audit data to be as secure as possible
>> from
>> malicious updates and deletes. This is to implement audit tracking for
>> SOX
>> compliance.
>> Thanks
>>
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>> I'm looking for a good commercial, 3rd party solution, not a Trace
>> solution.
>> Can anyone provide comments on something they have in production? So
>> far, my limited research has turned up Lumigent Entegra, and RippleTech
>> LogCaster.
>> My goal is to track DML changes by login with minimal impact on system
>> performance. Further, I need the audit data to be as secure as possible
>> from
>> malicious updates and deletes. This is to implement audit tracking for
>> SOX
>> compliance.
>> Thanks
>>
Subscribe to:
Posts (Atom)