|
|
You're in the
sql server programming
group:viewing differences between 2 db's (dev and production)
sql server programming:
I have a production database which absoutly has to be perfect as it is used regulary. and a development database which we do all the dev work on and constnatly loose track of what was changed and what is still the same... does anyone know of a tool that can show you the differences between database's DML? like i want to know what all i changed in the dev database so i can update the live db to resemble it so when the new software rollout occures it has the correct database format. thanks!
Check out a tool called SQL Compare from www.red-gate.com
-- Andrew J. Kelly SQL MVP [quoted text, click to view] "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... > I would have to think this would be a common question for developers... > > I have a production database which absoutly has to be perfect as it is used > regulary. and a development database which we do all the dev work on and > constnatly loose track of what was changed and what is still the same... > does anyone know of a tool that can show you the differences between > database's DML? like i want to know what all i changed in the dev database > so i can update the live db to resemble it so when the new software rollout > occures it has the correct database format. thanks! > >
thats a nice tool, but unfortinuatly we ran out our development budget for
this year... is there any freeware comparision apps out there anywhere? thanks [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:%23Avo5J3oEHA.1176@TK2MSFTNGP12.phx.gbl... > Check out a tool called SQL Compare from www.red-gate.com > > > -- > Andrew J. Kelly SQL MVP > > > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message > news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... >> I would have to think this would be a common question for developers... >> >> I have a production database which absoutly has to be perfect as it is > used >> regulary. and a development database which we do all the dev work on and >> constnatly loose track of what was changed and what is still the same... >> does anyone know of a tool that can show you the differences between >> database's DML? like i want to know what all i changed in the dev >> database >> so i can update the live db to resemble it so when the new software > rollout >> occures it has the correct database format. thanks! >> >> > >
Not any that I would depend on... red-gate is the one.
-- 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 [quoted text, click to view] "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message news:OR$wrN3oEHA.324@TK2MSFTNGP11.phx.gbl... > thats a nice tool, but unfortinuatly we ran out our development budget for > this year... is there any freeware comparision apps out there anywhere? > thanks > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23Avo5J3oEHA.1176@TK2MSFTNGP12.phx.gbl... > > Check out a tool called SQL Compare from www.red-gate.com > > > > > > -- > > Andrew J. Kelly SQL MVP > > > > > > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message > > news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... > >> I would have to think this would be a common question for developers... > >> > >> I have a production database which absoutly has to be perfect as it is > > used > >> regulary. and a development database which we do all the dev work on and > >> constnatly loose track of what was changed and what is still the same... > >> does anyone know of a tool that can show you the differences between > >> database's DML? like i want to know what all i changed in the dev > >> database > >> so i can update the live db to resemble it so when the new software > > rollout > >> occures it has the correct database format. thanks! > >> > >> > > > > > >
Hi
I don't know off any freeware tool to do this. I believe DBGhost www.innovartis.co.uk/Home.aspx may have similar functionality. The best way to overcome this is to avoid it completely and use version control for your code. You may be able to do something with the scripting options of DMO, but there are a few quirks that may give you false hits. John [quoted text, click to view] "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message news:OR$wrN3oEHA.324@TK2MSFTNGP11.phx.gbl... > thats a nice tool, but unfortinuatly we ran out our development budget for > this year... is there any freeware comparision apps out there anywhere? > thanks > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23Avo5J3oEHA.1176@TK2MSFTNGP12.phx.gbl... > > Check out a tool called SQL Compare from www.red-gate.com > > > > > > -- > > Andrew J. Kelly SQL MVP > > > > > > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message > > news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... > >> I would have to think this would be a common question for developers... > >> > >> I have a production database which absoutly has to be perfect as it is > > used > >> regulary. and a development database which we do all the dev work on and > >> constnatly loose track of what was changed and what is still the same... > >> does anyone know of a tool that can show you the differences between > >> database's DML? like i want to know what all i changed in the dev > >> database > >> so i can update the live db to resemble it so when the new software > > rollout > >> occures it has the correct database format. thanks! > >> > >> > > > > > >
A single user license for the compare tool is just $195.00. You can waste
much more in that just trying to find something. This will get you what you want (and more) in a few minutes. I don't know about you but my time is worth something and it's hard to do something yourself or with free tools that will save you more than $195.00. -- Andrew J. Kelly SQL MVP [quoted text, click to view] "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message news:OR$wrN3oEHA.324@TK2MSFTNGP11.phx.gbl... > thats a nice tool, but unfortinuatly we ran out our development budget for > this year... is there any freeware comparision apps out there anywhere? > thanks > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23Avo5J3oEHA.1176@TK2MSFTNGP12.phx.gbl... > > Check out a tool called SQL Compare from www.red-gate.com > > > > > > -- > > Andrew J. Kelly SQL MVP > > > > > > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message > > news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... > >> I would have to think this would be a common question for developers... > >> > >> I have a production database which absoutly has to be perfect as it is > > used > >> regulary. and a development database which we do all the dev work on and > >> constnatly loose track of what was changed and what is still the same... > >> does anyone know of a tool that can show you the differences between > >> database's DML? like i want to know what all i changed in the dev > >> database > >> so i can update the live db to resemble it so when the new software > > rollout > >> occures it has the correct database format. thanks! > >> > >> > > > > > >
You can try quasi-freeware (requires a downloading a new key every 60 days, but
still free) Quest Central® for SQL Server at http://www.quest.com/quest_central/sql_server/freeware/ The program has a quite a few utilities so here's a quick step guide for comparing: * After "Registering" your production and development servers under the "SQL Server Group", click on Tools => SQL Server => Compare. * Select the databases to compare in the left and right pane. * Select the objects you want to include in the compare (far right side). * Click on "Compare". It will show you the differences between tables, views, SP's, etc. but will not create scripts to actually sync one database to another (at least I haven't seen such an option). The download also includes "Spotlight" to monitor the performance for both SQL Server and the OS. It is one the most visual pleasing GUI's I have seen. Also, it allows yo to set your own warning/alert thresholds on the performance objects it montors and to drill down into them as well. On Sat, 25 Sep 2004 19:02:44 -0400, "Brian Henry" [quoted text, click to view] <brianiupmsdn@newsgroups.nospam> wrote:
>I would have to think this would be a common question for developers... > >I have a production database which absoutly has to be perfect as it is used >regulary. and a development database which we do all the dev work on and >constnatly loose track of what was changed and what is still the same... >does anyone know of a tool that can show you the differences between >database's DML? like i want to know what all i changed in the dev database >so i can update the live db to resemble it so when the new software rollout >occures it has the correct database format. thanks! > >
you should try talking to our finance person then ;) they seem to see
differntly... I know exactly what you mean though... but the way they see it its cheaper to spend months for us to make it ourselfs then spend the $200 (of which it turns out to cost way more to make it ourselfs because one day alone of work we already spent way over the 200)... [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:%23txLROApEHA.4004@TK2MSFTNGP10.phx.gbl... >A single user license for the compare tool is just $195.00. You can waste > much more in that just trying to find something. This will get you what > you > want (and more) in a few minutes. I don't know about you but my time is > worth something and it's hard to do something yourself or with free tools > that will save you more than $195.00. > > > -- > Andrew J. Kelly SQL MVP > > > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message > news:OR$wrN3oEHA.324@TK2MSFTNGP11.phx.gbl... >> thats a nice tool, but unfortinuatly we ran out our development budget >> for >> this year... is there any freeware comparision apps out there anywhere? >> thanks >> >> >> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >> news:%23Avo5J3oEHA.1176@TK2MSFTNGP12.phx.gbl... >> > Check out a tool called SQL Compare from www.red-gate.com >> > >> > >> > -- >> > Andrew J. Kelly SQL MVP >> > >> > >> > "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message >> > news:%23NSmFP1oEHA.1576@TK2MSFTNGP12.phx.gbl... >> >> I would have to think this would be a common question for >> >> developers... >> >> >> >> I have a production database which absoutly has to be perfect as it is >> > used >> >> regulary. and a development database which we do all the dev work on > and >> >> constnatly loose track of what was changed and what is still the > same... >> >> does anyone know of a tool that can show you the differences between >> >> database's DML? like i want to know what all i changed in the dev >> >> database >> >> so i can update the live db to resemble it so when the new software >> > rollout >> >> occures it has the correct database format. thanks! >> >> >> >> >> > >> > >> >> > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |