How to detect any changes made in Dev DB compared to Live DB

Hi,
I was just wondering if there's any way to detect what database objects
were lately modified in Dev database as compared to the similar one in Live
database.
When I develop in Dev datatabse, its very tough to keep track of all the
activities & changes that I do.
Is there a T-SQL where I can run it in a snapshot and know what tables,
columns, views, stored procs, triggers, user-defined function, etc. differ
than that in Live database.
This way, I know which objects to publish from Dev to Live.
Thanks,
Sam.
Message posted via http://www.sqlmonster.com
Nothing directly that comes with SQL Server. You can try
third party tools to do this - one is SQL Compare from Red
Gate:
http://www.red-gate.com/sql/summary.htm
The only free thing I know of is a script on
sql-server-performance.com which compares databases. Check
the following article:
http://www.sql-server-performance.co...parison_sp.asp
-Sue
On Tue, 15 Mar 2005 21:47:54 GMT, "Sameer Premji via
SQLMonster.com" <forum@.SQLMonster.com> wrote:

>Hi,
>I was just wondering if there's any way to detect what database objects
>were lately modified in Dev database as compared to the similar one in Live
>database.
>When I develop in Dev datatabse, its very tough to keep track of all the
>activities & changes that I do.
>Is there a T-SQL where I can run it in a snapshot and know what tables,
>columns, views, stored procs, triggers, user-defined function, etc. differ
>than that in Live database.
>This way, I know which objects to publish from Dev to Live.
>Thanks,
>Sam.

How to detect any changes made in Dev DB compared to Live DB

Hi,
I was just wondering if there's any way to detect what database objects
were lately modified in Dev database as compared to the similar one in Live
database.
When I develop in Dev datatabse, its very tough to keep track of all the
activities & changes that I do.
Is there a T-SQL where I can run it in a snapshot and know what tables,
columns, views, stored procs, triggers, user-defined function, etc. differ
than that in Live database.
This way, I know which objects to publish from Dev to Live.
Thanks,
Sam.
--
Message posted via http://www.sqlmonster.comNothing directly that comes with SQL Server. You can try
third party tools to do this - one is SQL Compare from Red
Gate:
http://www.red-gate.com/sql/summary.htm
The only free thing I know of is a script on
sql-server-performance.com which compares databases. Check
the following article:
http://www.sql-server-performance.com/vg_database_comparison_sp.asp
-Sue
On Tue, 15 Mar 2005 21:47:54 GMT, "Sameer Premji via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Hi,
>I was just wondering if there's any way to detect what database objects
>were lately modified in Dev database as compared to the similar one in Live
>database.
>When I develop in Dev datatabse, its very tough to keep track of all the
>activities & changes that I do.
>Is there a T-SQL where I can run it in a snapshot and know what tables,
>columns, views, stored procs, triggers, user-defined function, etc. differ
>than that in Live database.
>This way, I know which objects to publish from Dev to Live.
>Thanks,
>Sam.

How to detect any changes made in Dev DB compared to Live DB

Hi,
I was just wondering if there's any way to detect what database objects
were lately modified in Dev database as compared to the similar one in Live
database.
When I develop in Dev datatabse, its very tough to keep track of all the
activities & changes that I do.
Is there a T-SQL where I can run it in a snapshot and know what tables,
columns, views, stored procs, triggers, user-defined function, etc. differ
than that in Live database.
This way, I know which objects to publish from Dev to Live.
Thanks,
Sam.
Message posted via http://www.droptable.comNothing directly that comes with SQL Server. You can try
third party tools to do this - one is SQL Compare from Red
Gate:
http://www.red-gate.com/sql/summary.htm
The only free thing I know of is a script on
sql-server-performance.com which compares databases. Check
the following article:
http://www.sql-server-performance.c...mparison_sp.asp
-Sue
On Tue, 15 Mar 2005 21:47:54 GMT, "Sameer Premji via
droptable.com" <forum@.droptable.com> wrote:

>Hi,
>I was just wondering if there's any way to detect what database objects
>were lately modified in Dev database as compared to the similar one in Live
>database.
>When I develop in Dev datatabse, its very tough to keep track of all the
>activities & changes that I do.
>Is there a T-SQL where I can run it in a snapshot and know what tables,
>columns, views, stored procs, triggers, user-defined function, etc. differ
>than that in Live database.
>This way, I know which objects to publish from Dev to Live.
>Thanks,
>Sam.

How to deploy updated database from development environment to live environment?

I have finished a change request from our client. I need to update clients' database with the one in developments.
Here is the changes i made to database:
Added/Changed some tables
Added/Changed some stored procedures
Added data to some dictionary table
The data in clients' current database MUST be kept.
So how can I merge the changed information to clients' database?

Create update script and run it on client database. It is always good to maintain update script.
For example:
If you create a table/SP, use create script
If you change the table structure/SP code, use alter script, so you can retain data
Set of insert and/or update statements to take care of dictionary data.

|||

potturi_rp wrote:

Create update script and run it on client database. It is always good to maintain update script.
For example:
If you change the table structure/SP code, use alter script, so you can retain data

Hi, Sam,

Thank you for your help! I am not very clear about "use alter script, so you can retain data". Could you explain further, or could you send me some documents or hyperlinks about this? My email address ischarles.du@.hotmail.com
Thanks a million!
Regards,
Charles

|||If you are adding a column to a table, user ALTER TABLE to add the column. That way you donot loose data.