Comparing changes between two SQL Server installations?

Hi all,
I've just inherited an unusual problem and I need some recommendations and
advice.
My employer has a SQL Server 2000 installation on which they run their whole
operation, with roughly 100 tables, a few dozen stored procedures and views,
and various user logins. Prior to his departure, our most recent DBA did a
good deal of new SQL Server development in our development database
environment. Unfortunately, it appears he did *everything* through the
Enterprise Manager GUI, leaving no SQL scripts of any of his changes. Now my
employer wants me to figure out (A) what changes he made, and (2) generate
SQL script for all of those changes beforehand. That way, we can make those
same changes in production.
Other than manually comparing every single table, view, stored procedure,
and login, is there any tool (built-in or 3rd party) that will allow me to
reconcile the objects between two wholly separate SQL Server 2000
installations?
Essentially, to put it another way, I need to "diff" the whole schema and
any stored procs and generate files to allow me to implement those changes
against production. And, ideally, I need scripts allowing me to rollback
changes as well.
If not, is there at least some sort of source-control tool for SQL Server we
could try to use in the future?
Thanks!
--Phil
Philip P. Obbard wrote:
> Hi all,
> I've just inherited an unusual problem and I need some
> recommendations and advice.
> My employer has a SQL Server 2000 installation on which they run
> their whole operation, with roughly 100 tables, a few dozen stored
> procedures and views, and various user logins. Prior to his
> departure, our most recent DBA did a good deal of new SQL Server
> development in our development database environment. Unfortunately,
> it appears he did *everything* through the Enterprise Manager GUI,
> leaving no SQL scripts of any of his changes. Now my employer wants
> me to figure out (A) what changes he made, and (2) generate SQL
> script for all of those changes beforehand. That way, we can make
> those same changes in production.
> Other than manually comparing every single table, view, stored
> procedure, and login, is there any tool (built-in or 3rd party) that
> will allow me to reconcile the objects between two wholly separate
> SQL Server 2000 installations?
> Essentially, to put it another way, I need to "diff" the whole schema
> and any stored procs and generate files to allow me to implement
> those changes against production. And, ideally, I need scripts
> allowing me to rollback changes as well.
> If not, is there at least some sort of source-control tool for SQL
> Server we could try to use in the future?
> Thanks!
> --Phil
There are a number of available products onthe market that perform
schema comparisons and produce the necessary DDL. We offer Speed Change
Manager from the Imceda web site. You can try it for 14-days.
David Gugick
Imceda Software
www.imceda.com
|||you should take a look at DB Ghost which can help you manage all your changes
to your schema and static data allowing you to store and use the sql
defintions of all objects and static data within your source control giving
you total automated change management with the auditability features of your
source control so this thing will never happen again and you can quickly
assertain exactly what has happened.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"Philip P. Obbard" wrote:

> Hi all,
> I've just inherited an unusual problem and I need some recommendations and
> advice.
> My employer has a SQL Server 2000 installation on which they run their whole
> operation, with roughly 100 tables, a few dozen stored procedures and views,
> and various user logins. Prior to his departure, our most recent DBA did a
> good deal of new SQL Server development in our development database
> environment. Unfortunately, it appears he did *everything* through the
> Enterprise Manager GUI, leaving no SQL scripts of any of his changes. Now my
> employer wants me to figure out (A) what changes he made, and (2) generate
> SQL script for all of those changes beforehand. That way, we can make those
> same changes in production.
> Other than manually comparing every single table, view, stored procedure,
> and login, is there any tool (built-in or 3rd party) that will allow me to
> reconcile the objects between two wholly separate SQL Server 2000
> installations?
> Essentially, to put it another way, I need to "diff" the whole schema and
> any stored procs and generate files to allow me to implement those changes
> against production. And, ideally, I need scripts allowing me to rollback
> changes as well.
> If not, is there at least some sort of source-control tool for SQL Server we
> could try to use in the future?
> Thanks!
> --Phil
>
>

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

Command line installation of SQL Server 2005 Express with Advanced Features

Hi,

I'm trying to install SQL Express 2005 with Reporting Services using Install Shield 11.5. The command line parameters which i am using is:

/qn ADDLOCAL=SQL_Engine,SQL_Data_Files,RS_Server,RS_Web_Interface,Client_Components SECURITYMODE=SQL SAPWD=<password> DISABLENETWORKPROTOCOLS=0 RSCONFIGURATION=Default RSSQLLOCAL=1 AUTOSTART=1

It installs the SQL Server and Reporting Services. It configures (creates Virtual Directories for report server and database) but it is not initializing the Report Server.

Having done the installation when i check the Report Server Status it was running and everything seems to be OK except it wasn't initialized.

Any idea?

Thanks,

Moby.

It's been a long time since I've played around with this, but I think it is the RSCONFIGURATION command.

Here's the snippet from template.ini. It looks like the default is FilesOnly, which does not configure RS. Can you try it with the Default value and let us know if it works?

;--
; RSCONFIGURATION specifies the Reporting Services installation option.

; The installation options can be either “FilesOnly” or “Default”.
; The “FilesOnly” option will only install the files without configuring the Reporting Services.
; The “Default” option will install the files and configure the Reporting Services.
; If you specify RSCONFIGURATION=Default, you must set RSSQLLOCAL=1
; NOTE: If no option is specified the default is “FilesOnly”.
; For example:
; RSCONFIGURATION=Default
; RSCONFIGURATION=FilesOnly

Thanks,
Sam Lester (MSFT)

|||Hi,

Well i am using the Default configuration option as if you look at the parameters in my previous post. As i said before it does all configuration except initializing the server.

But now i have figured it out. Thanks for your efforts. Having installed it with the parameters used in my previous message, you need to restart the PC. Once it is restarted the server will be initialized.

Thanks,
Mubashir