Comparing two databases

Are there any tools that allow you to compare two sql server databases to
find out what is different between them (the database structure, including
tables, relationships etc)? Thanks,
- Gabe
http://www.red-gate.com/sql/summary.htm
AMB
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>
|||Gabe Matteson wrote:
> Are there any tools that allow you to compare two sql server
> databases to find out what is different between them (the database
> structure, including tables, relationships etc)? Thanks,
> - Gabe
There are numerous schema comparison tools available. Change Manager
from Imceda/Quest Software available at www.imceda.com.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Seconding this one...I've been using Red-gate SQL and Data compare for 2
years...fantastic products...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...[vbcol=seagreen]
> http://www.red-gate.com/sql/summary.htm
>
> AMB
> "Gabe Matteson" wrote:
|||Thanks!
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
|||ErWin and ER-Studio do this as well.
Greg Jackson
PDX, Oregon
|||I agree. SQL Compare from Red Gate is brilliant.
"Kevin3NF" wrote:

> Seconding this one...I've been using Red-gate SQL and Data compare for 2
> years...fantastic products...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...
>
>
|||you may want to look at a complete approach to change management, from your
favourite source control to your target database - DB Ghost
http://www.dbghost.com & the scripts produced always work - it's all in the
way they're produced.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>
|||I use red-gate
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
|||when red-gate fails (script out put has errors), DB Ghost succeeds which is
why most of our customers used to be red-gate customers.
free for MVP's, educational and non-profit organizations.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Wayne Snyder" wrote:

> I use red-gate
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
> news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
>
>

Comparing two databases

Are there any tools that allow you to compare two sql server databases to
find out what is different between them (the database structure, including
tables, relationships etc)? Thanks,
- Gabehttp://www.red-gate.com/sql/summary.htm
AMB
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>|||Gabe Matteson wrote:
> Are there any tools that allow you to compare two sql server
> databases to find out what is different between them (the database
> structure, including tables, relationships etc)? Thanks,
> - Gabe
There are numerous schema comparison tools available. Change Manager
from Imceda/Quest Software available at www.imceda.com.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Seconding this one...I've been using Red-gate SQL and Data compare for 2
years...fantastic products...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...[vbcol=seagreen]
> http://www.red-gate.com/sql/summary.htm
>
> AMB
> "Gabe Matteson" wrote:
>|||Thanks!
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>|||ErWin and ER-Studio do this as well.
Greg Jackson
PDX, Oregon|||I agree. SQL Compare from Red Gate is brilliant.
"Kevin3NF" wrote:

> Seconding this one...I've been using Red-gate SQL and Data compare for 2
> years...fantastic products...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...
>
>|||you may want to look at a complete approach to change management, from your
favourite source control to your target database - DB Ghost
http://www.dbghost.com & the scripts produced always work - it's all in the
way they're produced.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>|||I use red-gate
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>|||when red-gate fails (script out put has errors), DB Ghost succeeds which is
why most of our customers used to be red-gate customers.
free for MVP's, educational and non-profit organizations.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Wayne Snyder" wrote:

> I use red-gate
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
> news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
>
>sqlsql

Comparing two databases

Are there any tools that allow you to compare two sql server databases to
find out what is different between them (the database structure, including
tables, relationships etc)? Thanks,
- Gabe
http://www.red-gate.com/sql/summary.htm
AMB
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>
|||Gabe Matteson wrote:
> Are there any tools that allow you to compare two sql server
> databases to find out what is different between them (the database
> structure, including tables, relationships etc)? Thanks,
> - Gabe
There are numerous schema comparison tools available. Change Manager
from Imceda/Quest Software available at www.imceda.com.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Seconding this one...I've been using Red-gate SQL and Data compare for 2
years...fantastic products...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...[vbcol=seagreen]
> http://www.red-gate.com/sql/summary.htm
>
> AMB
> "Gabe Matteson" wrote:
|||Thanks!
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
|||ErWin and ER-Studio do this as well.
Greg Jackson
PDX, Oregon
|||I agree. SQL Compare from Red Gate is brilliant.
"Kevin3NF" wrote:

> Seconding this one...I've been using Red-gate SQL and Data compare for 2
> years...fantastic products...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...
>
>
|||you may want to look at a complete approach to change management, from your
favourite source control to your target database - DB Ghost
http://www.dbghost.com & the scripts produced always work - it's all in the
way they're produced.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Gabe Matteson" wrote:

> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>
|||I use red-gate
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
|||when red-gate fails (script out put has errors), DB Ghost succeeds which is
why most of our customers used to be red-gate customers.
free for MVP's, educational and non-profit organizations.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Wayne Snyder" wrote:

> I use red-gate
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
> news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
>
>

Comparing two databases

Are there any tools that allow you to compare two sql server databases to
find out what is different between them (the database structure, including
tables, relationships etc)? Thanks,
- Gabehttp://www.red-gate.com/sql/summary.htm
AMB
"Gabe Matteson" wrote:
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>|||Gabe Matteson wrote:
> Are there any tools that allow you to compare two sql server
> databases to find out what is different between them (the database
> structure, including tables, relationships etc)? Thanks,
> - Gabe
There are numerous schema comparison tools available. Change Manager
from Imceda/Quest Software available at www.imceda.com.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Seconding this one...I've been using Red-gate SQL and Data compare for 2
years...fantastic products...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...
> http://www.red-gate.com/sql/summary.htm
>
> AMB
> "Gabe Matteson" wrote:
>> Are there any tools that allow you to compare two sql server databases to
>> find out what is different between them (the database structure,
>> including
>> tables, relationships etc)? Thanks,
>> - Gabe
>>|||Thanks!
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>|||ErWin and ER-Studio do this as well.
Greg Jackson
PDX, Oregon|||I agree. SQL Compare from Red Gate is brilliant.
"Kevin3NF" wrote:
> Seconding this one...I've been using Red-gate SQL and Data compare for 2
> years...fantastic products...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:E8C28859-7C90-4FD6-A40B-3490F7172846@.microsoft.com...
> > http://www.red-gate.com/sql/summary.htm
> >
> >
> > AMB
> >
> > "Gabe Matteson" wrote:
> >
> >> Are there any tools that allow you to compare two sql server databases to
> >> find out what is different between them (the database structure,
> >> including
> >> tables, relationships etc)? Thanks,
> >> - Gabe
> >>
> >>
> >>
>
>|||you may want to look at a complete approach to change management, from your
favourite source control to your target database - DB Ghost
http://www.dbghost.com & the scripts produced always work - it's all in the
way they're produced.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Gabe Matteson" wrote:
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>
>|||I use red-gate
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>|||when red-gate fails (script out put has errors), DB Ghost succeeds which is
why most of our customers used to be red-gate customers.
free for MVP's, educational and non-profit organizations.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Wayne Snyder" wrote:
> I use red-gate
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
> news:OdFamzndFHA.1456@.TK2MSFTNGP15.phx.gbl...
> > Are there any tools that allow you to compare two sql server databases to
> > find out what is different between them (the database structure, including
> > tables, relationships etc)? Thanks,
> > - Gabe
> >
>
>|||'www.red-gate.com' (http://www.red-gate.com) or 'www.dbghost.com
(http://www.dbghost.com) are two software use to compare the databas
--
gheman
----
ghemant's Profile: http://www.msusenet.com/member.php?userid=234
View this thread: http://www.msusenet.com/t-187055366|||I use http://www.adeptsql.com SQL Diff Tool because it was so much
faster than red-gate.
Tim S|||Ive seen people script DBs and use "Beyond Compare" as well.
Greg Jackson
PDX, Oregon|||I use SQL Effects Clarity from http://www.sqleffects.com mostly because
of the side by side twin views of the schemas that lets you drill down
to the most minute differences.
Gabe Matteson wrote:
> Are there any tools that allow you to compare two sql server databases to
> find out what is different between them (the database structure, including
> tables, relationships etc)? Thanks,
> - Gabe
>

Comparing Log Tools

I've only ever used built in SQL Server tools but have been looking at
log tools. I looked at Log Explorer 4.02 from lumigent.com and was very
impressed with what I saw. The prices tag per instance was a bit hefty
I felt though. I've been over to LogPI.com and am reading some of the
"features" I've yet to d/l the evaluation demo. The price is over half
that of Log Explorer (I'm converting to local currency on the fly
here).
Questions... logPI any good? Log Explorer worth the extra $?
Anyone using either and have any opinions to share?
Are 3rd party tools worthwhile?

Unrelated but for my info... does/will Yukon come with a similar built
in tool? I haven't had a chance to look at Yukon yet.
Cheers
Jay<JazeMail@.gmail.com> wrote:

> I've only ever used built in SQL Server tools but have been looking at
> log tools. I looked at Log Explorer 4.02 from lumigent.com and was very
> impressed with what I saw. The prices tag per instance was a bit hefty
> I felt though. I've been over to LogPI.com and am reading some of the
> "features" I've yet to d/l the evaluation demo. The price is over half
> that of Log Explorer (I'm converting to local currency on the fly
> here).
> Questions... logPI any good? Log Explorer worth the extra $?
> Anyone using either and have any opinions to share?
> Are 3rd party tools worthwhile?
> Unrelated but for my info... does/will Yukon come with a similar built
> in tool? I haven't had a chance to look at Yukon yet.
> Cheers
> Jay

Jay,

[I have no affiliation with Lumigent other than as a satisfied customer.]

When we bought Log Explorer (about 8 months ago), we didn't evaluate LogPI,
so I can't comment on it. However, we've been very happy with Log Explorer
and what we're able to do with it. I probably traded 4 or 5 emails with
technical staff and had one conference call before we bought it: they were
very knowledgeable and very forthcoming. After we purchased it, every email
I sent to our technical contact was answered promptly (some in less than 15
minutes). It's still my feeling that the technical and sales support we got
went beyond the norm for software in that price range.

Overall, we feel like we got much more than our money's worth. To put the
money in perspective, our company is considered small (privately owned, ca
150 employees) and while we're not averse to spending money it's not unusual
for us to go 3 - 12 months without spending any money on IT software.

Although we played with it extensively after we got it, our main reason to
buy was as a safety net (for when "OH CRAP!" was heard coming from a
developer's cubicle :). 8 months later, we actually get the most use out of
the various emails that can be sent by Log Explorer: now I actually know
when a developer decides to just recompile a new version of a stored proc on
the main database on our main data server. It's always nice to have
documentation before beating someone senseless :)

Of course, I'd have paid double if it had come with an SDK, but that's
another story entirely.

On the negative side, I have heard people (but I don't remember the source)
complain about tech support they received from Lumigent. We've had nothing
but positive things to say about them, but my experience isn't broad enough
to tell you if we're the exception or the norm.

Craig|||Many thanks for that Craig.
We have 2 developers here (myself and one other) and we do all testing
in the Dev environment before letting loose in the real world (99% of
the time if the truth be told) my interest in LE was the ability to
role back row level records (changes) rather than having to restore to
a point in time thus potentially losing other bonafide changes.
Jay|||"Jay" <JazeMail@.gmail.com> wrote:

> Many thanks for that Craig.
> We have 2 developers here (myself and one other) and we do all testing
> in the Dev environment before letting loose in the real world (99% of
> the time if the truth be told) my interest in LE was the ability to
> role back row level records (changes) rather than having to restore to
> a point in time thus potentially losing other bonafide changes.
> Jay

Jay,

You're welcome.

That's originally why we bought it as well (and the fact that we could look
at row-level changes: our system isn't fully audited). It works well for
fixing problems, but the farther away you get from the modification, the
less useful it is (obviously from a data integrity standpoint, but also
because of the sheer volume of transactions you have to pour through,
although there is a search function).

"99% of the time if the truth be told"

We have four actual developers and that's about how we handle it: but the 1%
was getting kinda hairy for us :)

One thing that I forgot: we have an automated build procedure that (among
other things) checks table schema and scripts stored procedures from test to
production. Running one of these builds results in about 2500 procs getting
re-scripted on production... It was quite a bit of fun the night of the
first build after installing Log Explorer when the first of about 5000
emails started rolling in (one for the DROP and one for the CREATE).

The problem here is that Log Explorer provides no documented interface to
automatically turn those emails on and off. Their technical people helped
us with the necessary changes so our steps look like:

- Delete specific rows from a table in the Lumigent database

- Fire off a Log Explorer extended procedure to notify the engine things
have changed (named xp_LEServer_TraceConfigure)

- Run the rest of the automated build

- Re-insert the deleted rows

- Call xp_LEServer_TraceConfigure again

This didn't bother us but some might consider it a PITA, especially if you
aren't that concerned with the emails in the first place (although you can
just turn them off permanently).

Craig

Comparing 2 databases

Using SAP's tools I have exported my SAP database and am now in the progress
of importing the exported data. This has been done as an experiment as I
have to do this in a few months time when we cluster our SAP system. When
the import has finished I will have both the original database and the new
imported database on the same SQL server (all this has been done on the same
machine). My question is this, is there a way I can compare the two
databases data wise? I understand the layout of the data will almost
certainly be different I am only concerned with data integrity.
thanks
Gav
Perhaps this will help you:
http://www.red-gate.com/SQL_Data_Compare.htm
Keith
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cv4i78$6un$1@.newsreaderg1.core.theplanet.net. ..
> Using SAP's tools I have exported my SAP database and am now in the
progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the
same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>
|||you could also check out DB Ghost - http://www.dbghost.com
"Gav" wrote:

> Using SAP's tools I have exported my SAP database and am now in the progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>
>

Comparing 2 databases

Using SAP's tools I have exported my SAP database and am now in the progress
of importing the exported data. This has been done as an experiment as I
have to do this in a few months time when we cluster our SAP system. When
the import has finished I will have both the original database and the new
imported database on the same SQL server (all this has been done on the same
machine). My question is this, is there a way I can compare the two
databases data wise? I understand the layout of the data will almost
certainly be different I am only concerned with data integrity.
thanks
GavPerhaps this will help you:
http://www.red-gate.com/SQL_Data_Compare.htm
Keith
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cv4i78$6un$1@.newsreaderg1.core.theplanet.net...
> Using SAP's tools I have exported my SAP database and am now in the
progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the
same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>|||you could also check out DB Ghost - http://www.dbghost.com
"Gav" wrote:

> Using SAP's tools I have exported my SAP database and am now in the progre
ss
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the sa
me
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>
>

Comparing 2 databases

Using SAP's tools I have exported my SAP database and am now in the progress
of importing the exported data. This has been done as an experiment as I
have to do this in a few months time when we cluster our SAP system. When
the import has finished I will have both the original database and the new
imported database on the same SQL server (all this has been done on the same
machine). My question is this, is there a way I can compare the two
databases data wise? I understand the layout of the data will almost
certainly be different I am only concerned with data integrity.
thanks
GavPerhaps this will help you:
http://www.red-gate.com/SQL_Data_Compare.htm
--
Keith
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cv4i78$6un$1@.newsreaderg1.core.theplanet.net...
> Using SAP's tools I have exported my SAP database and am now in the
progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the
same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>|||you could also check out DB Ghost - http://www.dbghost.com
"Gav" wrote:
> Using SAP's tools I have exported my SAP database and am now in the progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>
>sqlsql

Compare Tools and Replication

Does anyone know of a SQL Compare tool that allows for the disabling of
Replication when doing database compares?
I have a large number of identical merge replicated databases and am using
the Redgate SQL Compare tool. It is a great tool but always identifies every
table as a diff because of the different Replication trigger names. This
kinda defeats the point of using the tool because I still need to examine
every table to ensure consistency. I am looking for a compare tool that will
allow me to disable the comparing of all replication related db objects.
Anything out there?
I have the same issue running merge replication where there are
replication specific objects & a rowguid column in my article tables. I
use DB Ghost from Innovartis to manage my database changes & it ignores
the replication objects during a comparison. To avoid the rowguid
columns coming up as differences, I basically drop replication, drop the
rowguid columns & re-create replication. To do this, I create a file
containing the commands to drop the columns (DB Ghost can generate this
file) & use Enterprise Manager to generate scripts to drop & create my
publications, articles etc. These files are then passed as input to DB
Ghost & executed automatically either before or after the database
comparison.
John McGrath
SQL Server DBA MCSE
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Compact Tools Download Problem

When I try and download Sqlce30setupen.msi from the msdn site, I keep getting the install for the mobile tools. Can someone explain why this is happening. I am new to SQL compact and I am trying to go through the tutorial http://msdn2.microsoft.com/en-us/library/bb226707.aspx. This tutorial says the download should be for SQL Compact setup.

Thanks

Ryan

All downloads for SQL Compact Edition are available from http://www.microsoft.com/sql/editions/compact/downloads.mspx|||

Hi Ryan,

Are you having the same problem as me? When I download the setup file from the SQL Compact downloads url provided, it doesn't install the Compac Server Tools but tries to install "Microsoft SQL Server 2005 Mobile SP1 [ENU] Server Tools". I'm trying to install on Windows Server 2003. Interestingly if I run the same file on XP Pro it successfully installs the Compact Server Tools. I just added a new thread about this problem.

Regards,

Greg

Compact Tools Download Problem

When I try and download Sqlce30setupen.msi from the msdn site, I keep getting the install for the mobile tools. Can someone explain why this is happening. I am new to SQL compact and I am trying to go through the tutorial http://msdn2.microsoft.com/en-us/library/bb226707.aspx. This tutorial says the download should be for SQL Compact setup.

Thanks

Ryan

All downloads for SQL Compact Edition are available from http://www.microsoft.com/sql/editions/compact/downloads.mspx|||

Hi Ryan,

Are you having the same problem as me? When I download the setup file from the SQL Compact downloads url provided, it doesn't install the Compac Server Tools but tries to install "Microsoft SQL Server 2005 Mobile SP1 [ENU] Server Tools". I'm trying to install on Windows Server 2003. Interestingly if I run the same file on XP Pro it successfully installs the Compact Server Tools. I just added a new thread about this problem.

Regards,

Greg

command line tools to make flat backups

Does anyone know if there is a way to run a command at the DOS prompt
to make a complete flat file (.bak) backup of a database? I know you
can do this using the enterprise manager by right clicking on the
db..., but I am curious to find out if I can add a command into my
batch scripts as part of my code migration procedures?
Thanks!
-Mike
You could use osql e.g.
osql -Q "BACKUP DATABASE pubs TO DISK = 'e:\backups\pubs.bak'" -E
Ray Mond
|||Yes, Ray, Perfecto!! That's what I was looking for. Thanks for the
help...
Happy Holidays!!

Command line tools missing

I have read about the dtexec utility, but I can not find this on my installation. Is it a seperate install or do I need to reinstall?

Bob

How I found it was by clicking on Start-->Run then entering in dtexecui.exe|||

Bob Everland wrote:

I have read about the dtexec utility, but I can not find this on my installation. Is it a seperate install or do I need to reinstall?

Bob

You'll need to install SQL Server Integration Services. Installing Workstation components is not enough.

-Jamie