|
Home > Archive > MS SQL Server > July 2005 > Create an automated routine to check database definitions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Create an automated routine to check database definitions
|
|
| JasonDWilson 2005-07-27, 1:24 pm |
| Is there any utility, command, or query in SQL Server, that I can execute
from a batch mode to script out all of my database definitions (tables,
columns, sp, functions, indexes, constraints, triggers, etc.) so I can create
an automated routine to check database definitions?
--
Jason
| |
| Wojtek Garwol 2005-07-27, 8:23 pm |
| "JasonDWilson" < JasonDWilson@discuss
ions.microsoft.com> wrote in message
news:7B571D73-00F3-425B-BB96- 555A028AC91F@microso
ft.com...
> Is there any utility, command, or query in SQL Server, that I can execute
> from a batch mode to script out all of my database definitions (tables,
> columns, sp, functions, indexes, constraints, triggers, etc.) so I can
> create
> an automated routine to check database definitions?
I wrote one some time ago, using DMO. I can provide compiled exe or sources
if you want. AFAIR works only with integrated security (kind of bug I never
really needed to fix). Works fine if you need to monitor database (or all
databases) schema.
Cheers,
Wojtek
| |
| JasonDWilson 2005-07-27, 8:23 pm |
| Yes, that would be great. Can I get both? I will need to modify to work
with sql authentication.
Thanks,
--
Jason
"Wojtek Garwol" wrote:
> "JasonDWilson" < JasonDWilson@discuss
ions.microsoft.com> wrote in message
> news:7B571D73-00F3-425B-BB96- 555A028AC91F@microso
ft.com...
>
> I wrote one some time ago, using DMO. I can provide compiled exe or sources
> if you want. AFAIR works only with integrated security (kind of bug I never
> really needed to fix). Works fine if you need to monitor database (or all
> databases) schema.
>
> Cheers,
> Wojtek
>
>
>
| |
| Wojtek Garwol 2005-07-27, 8:23 pm |
| Sure:
http://www.garwol.net/DbCompare.src.zip
http://www.garwol.net/DbCompare.exe.zip
Enjoy :)
Cheers,
Wojtek
"JasonDWilson" < JasonDWilson@discuss
ions.microsoft.com> wrote in message
news:45287186-E6D8-47E8-8194- DB2523FDF881@microso
ft.com...[color=darkred]
> Yes, that would be great. Can I get both? I will need to modify to work
> with sql authentication.
>
> Thanks,
> --
> Jason
>
>
> "Wojtek Garwol" wrote:
>
|
|
|
|
|