468,484 Members | 1,581 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,484 developers. It's quick & easy.

create database: programmatically vs app-tools

Just wondering if anyone knows the pros/cons between creating a database
programmatically 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
programmatically 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
programmatically 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?
Nov 16 '05 #1
3 3516
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" <RR****@discussions.microsoft.com> wrote in message
news:89**********************************@microsof t.com...
Just wondering if anyone knows the pros/cons between creating a database
programmatically 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 programmatically 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
programmatically 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?

Nov 16 '05 #2
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:
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" <RR****@discussions.microsoft.com> wrote in message
news:89**********************************@microsof t.com...
Just wondering if anyone knows the pros/cons between creating a database
programmatically 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
programmatically 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
programmatically 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?


--
to reply, remove .s.p.a.m. from email
Nov 16 '05 #3
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:
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:
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" <RR****@discussions.microsoft.com> wrote in message
news:89**********************************@microsof t.com...
Just wondering if anyone knows the pros/cons between creating a database
programmatically 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
programmatically 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
programmatically 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?


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

Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jorge Cecílio | last post: by
3 posts views Thread by G rumpy O ld D uffer | last post: by
5 posts views Thread by Jacob | last post: by
11 posts views Thread by =?Utf-8?B?UGV0ZXIgSw==?= | last post: by
10 posts views Thread by AAaron123 | last post: by
2 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.