473,396 Members | 1,864 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Build SQL database during installation

Hi,

i) Is it possible to build the SQL database structure during the
installation of a C# applicaton? If yes, how?

Pls advice and thanks in advance

pcPirate
Nov 15 '05 #1
2 1465
"pcPirate" <ph****@hotmail.com> wrote in news:OLaICXdpDHA.1408
@TK2MSFTNGP11.phx.gbl:
Hi,

i) Is it possible to build the SQL database structure during the
installation of a C# applicaton? If yes, how?

Pls advice and thanks in advance

pcPirate


Yes it is.
Just connect to the master database of your database server and then start
a script similar to this one:

CREATE DATABASE newDatabase .....(lots of parameters here)

Use newDatabase
GO

CREATE TABLE .....
GO
CREATE TABLE .....
GO
CREATE VIEW .....
GO

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------
Nov 15 '05 #2
Thanks, but do you have any example? Maybe an appropriate website?

pcPirate
"Peter Koen" <koen-newsreply&snusnu.at> wrote in message
news:eN**************@TK2MSFTNGP09.phx.gbl...
"pcPirate" <ph****@hotmail.com> wrote in news:OLaICXdpDHA.1408
@TK2MSFTNGP11.phx.gbl:
Hi,

i) Is it possible to build the SQL database structure during the
installation of a C# applicaton? If yes, how?

Pls advice and thanks in advance

pcPirate


Yes it is.
Just connect to the master database of your database server and then start
a script similar to this one:

CREATE DATABASE newDatabase .....(lots of parameters here)

Use newDatabase
GO

CREATE TABLE .....
GO
CREATE TABLE .....
GO
CREATE VIEW .....
GO

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

Nov 15 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: fedor | last post by:
We are installing an application with MSSQL database at our users place. Now we have two instances of the same database: - developing database, on which we are working at - production database,...
0
by: Rob Young | last post by:
This is the latest in the "Total Non-Programmer" series. Any feedback on the usability of this tutorial would be greatly appreciated. Thanks, Rob How to Build A Web Database (Without...
6
by: H | last post by:
This is a question that has haunted me for quite some time. if you build a 4 tier database application where the 4th tier is the database server (MS SQL 2000), where do you build the connection...
0
by: pcgxk | last post by:
Due to some bugs in .NET SP1 which we are currently review with MS under separate cover, I am having to regress the patching levels of several of my desktops to rebuild and retest several versions...
5
by: Malcolm Webb | last post by:
Hello All, I had some considerable help from people in this forum a log while ago whilst developing a databse for use in our business. The database has developed beyond my wildest dreams over...
3
by: DC Gringo | last post by:
Hi, I'm trying to use a custom action to modify a database (rather than create one) using the VS.NET '03's help example called "Custom Action to Create Database During Installation". I've made...
1
by: Jake Pearson | last post by:
Hi, I just upgraded to VS 2005 from 2003, and builds have become much slower (like 10 times worse). I have noticed 2 things that I can not explain: 1. Everytime I build, I get a message on my...
5
by: Leanne | last post by:
I am doing customization for Microsoft Pos. I am working on installation package now. I added some new tables and stored procuedures and generated SQL Script for that. During the installation...
6
by: Soren | last post by:
Hi! I'm trying to extend my python program with some C++ code. Right now I've spent hours just trying to get boost to work! I'm trying to get the example hello.cpp to work. Using Windows XP...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.