Comparing DBs

We use the following tool
http://www.adeptsql.com/
Its cheap, very accurate, very fast and will also update
your out of sync database if you wish. There is also a
trial version which you can download.
J

quote:

---

>--Original Message--
>is there any utility or program available that will

---

compare two versions of

quote:

---

>the same SQL Server database in terms of definition and

---

objects. I don't

quote:

---

>want to compare data. I need to see the differences in

---

tables columns views

quote:

---

>etc.
>Thanks,
>Gary
>
>.
>

---

I downloaded it and tried it out. Works great. Many thanks.
Gary
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:0d0601c3d9fa$103b29b0$a601280a@.phx.gbl...[QUOTE]
> We use the following tool
> http://www.adeptsql.com/
> Its cheap, very accurate, very fast and will also update
> your out of sync database if you wish. There is also a
> trial version which you can download.
> J
>
> compare two versions of
> objects. I don't
> tables columns views

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!
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

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

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

Compare/Sync functions and plug-ins

I have two questions.

Q1 : (Note: I had posted a similar query in Data Dude (Visual Studio Team System for DB Professionals) forums and got an answer (nothing conclusive though). Given the context, thought this will also be a good forum to run the post). Onto my question :

Data Dude has Compare and Synchronization functionality for SQL Server. Are there any plans to integrate the same as part of SQL Server Management Studio ? We DBAs work only with SSMS and not Visual Studio. Are there any near term/long terms plans in this direction ?

My original post in Data Dude forums can be found here :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1016505&SiteID=1

Q2 : I came across this thread which discusses about developing Plug-ins for Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192769&SiteID=1
Any approximate time line by which we can expect this ?

Appreciate your response.

Krish

I believe it will be good if you have upadted the same on http://connect.microsoft.com/ with the requirement, as they are monitored on daily basis and your request might be considered in future releases of Service pack.

sqlsql