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