create database: programmatically vs app-tools

[R Reyes]

Just wondering if anyone knows the pros/cons between creating a database
programmaticall y vs using the application's tool windows/features that come
with SQLServer, Access, Oracle, etc...

Is it the same? Does it really matter? I have created databases with .NET
programmaticall y and it works fine, but why would anyone want to do all this
typing when they can easily point and click inside the program?

It took a few hours of typing for me to create the database and all its
tables. I am very certain that if i just point and clicked inside the
program it would've been done in less than an hour. So why do people
programmaticall y use SQL? Is it only on an as-needed basis or do many people
ALWAYS use this practice because it makes it more efficient/declarative?

[Mark]

Re: create database: programmaticall y vs app-tools

Once you've typed the syntax once ... you can save it in a .sql or text file
and reuse it over and over and over. Once it's written, no more clicking -
just modify for the new database, and then execute. Moreover, there are a
myriad of configuration issues that affect performance, security, etc., that
sometimes are easy to overlook in the GUI, and would have to be addressed by
reading through BOL to write the syntax yourself. Consider it a "healthy"
excercise that will treat you well over the long haul.

Good luck.

Mark

https://www.dovetaildatabases.com

"R Reyes" <RReyes@discuss ions.microsoft. com> wrote in message
news:895E9ABF-AB93-4FEC-9AE3-97A713D5A953@mi crosoft.com...[color=blue]
> Just wondering if anyone knows the pros/cons between creating a database
> programmaticall y vs using the application's tool windows/features that[/color]
come[color=blue]
> with SQLServer, Access, Oracle, etc...
>
> Is it the same? Does it really matter? I have created databases with[/color]
..NET[color=blue]
> programmaticall y and it works fine, but why would anyone want to do all[/color]
this[color=blue]
> typing when they can easily point and click inside the program?
>
> It took a few hours of typing for me to create the database and all its
> tables. I am very certain that if i just point and clicked inside the
> program it would've been done in less than an hour. So why do people
> programmaticall y use SQL? Is it only on an as-needed basis or do many[/color]
people[color=blue]
> ALWAYS use this practice because it makes it more efficient/declarative?[/color]

[Ben Bloom]

Re: create database: programmaticall y vs app-tools

It's easier to migrate changes through development -> Test -> Production
servers if the database is created in script. Just apply the script to
a different server/database and you're set.

If you use the GUI tools (which, I admit, are nice and easy) you have to
manually change each database.

Mark wrote:
[color=blue]
> Once you've typed the syntax once ... you can save it in a .sql or text file
> and reuse it over and over and over. Once it's written, no more clicking -
> just modify for the new database, and then execute. Moreover, there are a
> myriad of configuration issues that affect performance, security, etc., that
> sometimes are easy to overlook in the GUI, and would have to be addressed by
> reading through BOL to write the syntax yourself. Consider it a "healthy"
> excercise that will treat you well over the long haul.
>
> Good luck.
>
> Mark
> www.dovetaildatabases.com
>
> "R Reyes" <RReyes@discuss ions.microsoft. com> wrote in message
> news:895E9ABF-AB93-4FEC-9AE3-97A713D5A953@mi crosoft.com...
>[color=green]
>>Just wondering if anyone knows the pros/cons between creating a database
>>programmatica lly vs using the application's tool windows/features that[/color]
>
> come
>[color=green]
>>with SQLServer, Access, Oracle, etc...
>>
>>Is it the same? Does it really matter? I have created databases with[/color]
>
> .NET
>[color=green]
>>programmatica lly and it works fine, but why would anyone want to do all[/color]
>
> this
>[color=green]
>>typing when they can easily point and click inside the program?
>>
>>It took a few hours of typing for me to create the database and all its
>>tables. I am very certain that if i just point and clicked inside the
>>program it would've been done in less than an hour. So why do people
>>programmatica lly use SQL? Is it only on an as-needed basis or do many[/color]
>
> people
>[color=green]
>>ALWAYS use this practice because it makes it more efficient/declarative?[/color]
>
>
>[/color]


--
to reply, remove .s.p.a.m. from email

[R Reyes]

Re: create database: programmaticall y vs app-tools

Thanks for the replies.

From now on I think I will be creating all my databases with reusable
scripts.

Sounds like its definitely worth it.

"Ben Bloom" wrote:
[color=blue]
> It's easier to migrate changes through development -> Test -> Production
> servers if the database is created in script. Just apply the script to
> a different server/database and you're set.
>
> If you use the GUI tools (which, I admit, are nice and easy) you have to
> manually change each database.
>
> Mark wrote:
>[color=green]
> > Once you've typed the syntax once ... you can save it in a .sql or text file
> > and reuse it over and over and over. Once it's written, no more clicking -
> > just modify for the new database, and then execute. Moreover, there are a
> > myriad of configuration issues that affect performance, security, etc., that
> > sometimes are easy to overlook in the GUI, and would have to be addressed by
> > reading through BOL to write the syntax yourself. Consider it a "healthy"
> > excercise that will treat you well over the long haul.
> >
> > Good luck.
> >
> > Mark
> > www.dovetaildatabases.com
> >
> > "R Reyes" <RReyes@discuss ions.microsoft. com> wrote in message
> > news:895E9ABF-AB93-4FEC-9AE3-97A713D5A953@mi crosoft.com...
> >[color=darkred]
> >>Just wondering if anyone knows the pros/cons between creating a database
> >>programmatica lly vs using the application's tool windows/features that[/color]
> >
> > come
> >[color=darkred]
> >>with SQLServer, Access, Oracle, etc...
> >>
> >>Is it the same? Does it really matter? I have created databases with[/color]
> >
> > .NET
> >[color=darkred]
> >>programmatica lly and it works fine, but why would anyone want to do all[/color]
> >
> > this
> >[color=darkred]
> >>typing when they can easily point and click inside the program?
> >>
> >>It took a few hours of typing for me to create the database and all its
> >>tables. I am very certain that if i just point and clicked inside the
> >>program it would've been done in less than an hour. So why do people
> >>programmatica lly use SQL? Is it only on an as-needed basis or do many[/color]
> >
> > people
> >[color=darkred]
> >>ALWAYS use this practice because it makes it more efficient/declarative?[/color]
> >
> >
> >[/color]
>
>
> --
> to reply, remove .s.p.a.m. from email
>[/color]