471,330 Members | 1,111 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

MSI for create database and execute scripts

Hi mister,

I have an Winforms app (Client) and Web app + WCF Services + Windows
Services (Server). In server, I have installed SQL SERVER 2000.

Now, I want create a installer (MSI.exe or another Winforms app) to create a
database, perhaps user, tables, stored procedures, .. Only the user
introduces name of database, server, and if has Windows authentication; if
not Windows authentication, I need user and password.

I have several scripts SQL, that I need execute too. If I use isql command I
have problmes with codification because my scripts sql have Spanish
characters. I tested with using ANSI and UTF-8 encoding for scripts .sql
files, but didn't work.

Finally, how I can create this installer ? is it better MSI ?? or can I
create an WinForms app ??

Any sample will be very very grateful.

Thanks in advance.
--
http://www.alhambra-eidos.es/web2005/index.html
www.kiquenet.net
http://www.setbb.com/putainformatica...opic.php?p=843
www.trabajobasura.com/solusoft

Sep 15 '08 #1
1 3697
"Alhambra Eidos Kiquenet" <Al*******************@discussions.microsoft.com >
wrote in message news:C1**********************************@microsof t.com...
I have an Winforms app (Client) and Web app + WCF Services + Windows
Services (Server). In server, I have installed SQL SERVER 2000.

Now, I want create a installer (MSI.exe or another Winforms app) to create
a
database, perhaps user, tables, stored procedures, .. Only the user
introduces name of database, server, and if has Windows authentication; if
not Windows authentication, I need user and password.

I have several scripts SQL, that I need execute too. If I use isql command
I
have problmes with codification because my scripts sql have Spanish
characters. I tested with using ANSI and UTF-8 encoding for scripts .sql
files, but didn't work.

Finally, how I can create this installer ? is it better MSI ?? or can I
create an WinForms app ??
You can use an installer project in Visual Studio. You add a Custom
Action, and then program your custom action to send the scripts into the
database server. There is an example in MSDN here:

http://msdn.microsoft.com/en-us/library/49b92ztk.aspx
Sep 15 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by gruber | last post: by
4 posts views Thread by Nanda | last post: by
1 post views Thread by Eric Wood | last post: by
1 post views Thread by jatinder.saundh | last post: by
1 post views Thread by Sue | last post: by

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.