Distributing SQL with a program

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a program that uses Access DB that is distributed with the program. I
would like to upgrade these to the SQL server that is distributed with the
program. This program needs to run as a standalone, not connected to a
server. So the SQL engine and data, log file need to be distributed with the
EXE. I am using .NET 2.0, ADO, and VS 2005I have already converted the DB to
the SQL 2005 and can access the structure and data using a dataset. I have
several questions on how to do this.
MSDN talks about a MSDE, Native client, SQL Everywhere, and that SQL Express
can be distributed.
Which client/server do I use?
Are these the same?
Can these be used by the click-once technology?
It is my understanding this was to be available in .NET 2.0 and VS2005.
Where can I get documentation how to disturbed SQL with a program?
If I am not in the correct news group please advise me which on I should be
in.
Thank you,
 
I have a program that uses Access DB that is distributed with the program. I
would like to upgrade these to the SQL server that is distributed with the
program. This program needs to run as a standalone, not connected to a
server. So the SQL engine and data, log file need to be distributed with the
EXE. I am using .NET 2.0, ADO, and VS 2005I have already converted the DB to
the SQL 2005 and can access the structure and data using a dataset. I have
several questions on how to do this.
MSDN talks about a MSDE, Native client, SQL Everywhere, and that SQL Express
can be distributed.
Which client/server do I use?
Are these the same?
Can these be used by the click-once technology?
It is my understanding this was to be available in .NET 2.0 and VS2005.
Where can I get documentation how to disturbed SQL with a program?
If I am not in the correct news group please advise me which on I should be
in.
Thank you,
Click to expand...

I think SQL server Express is your best bet. Here is a place to get started.
http://msdn.microsoft.com/sql/express/
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
 
Hi Mike,

SQL Express is the 2005 version of MSDE. It is a desktop engine of SQL
Server which is free to be downloaded. The Native Client is a provider that
enables you to connect to SQL Server or SQL Express from your app.

If you would like to have a substitute for Access DB, use SQL Express.

Click-once is a technology to help you deploy your app to client. The SQL
Express itself cannot be deployed with click-once. However, your app can be
deployed by click-once and connect to the SQL DB

HTH.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Hi Michael,

I would certainly look into Sql Everywhere if I being you.
No installation hassles - just deploy required assembly (or assemblies).
It isn't released yet, but you can find a beta download somewhere.
 
Mike:

I agree with the others that SQL Express is the way to go. I have used it
quite a few times and have found it very easy to use. In one case, we did use
Click Once to deploy the solution. You can mark SQL Express as a prerequesite
and it will be copied to the virtual directory.

Because changes to the database structure can occur and we did not want to
have to recreate a SQL file with create and alter table statements, we
created an xml web service that uses SMO (Server Management Objects) to
iterate through a "database schema" sql database and builds a strongly typed
dataset that contains all of the tables that are in the database. In each of
the tables, the rows are the columns. The columns in each table are the
properties that will have to be set in each of the databases on the target
machine.

When the program ran the first time, the program checked for the existence
of the database and created it using SMO if it did not exist.

Click Once works great.

Through the use of click once and xml web services, you have all of the
functionality of a windows forms application and the application is always up
to date, just like an ASP.net application

Miha Markic said:
Hi Michael,

I would certainly look into Sql Everywhere if I being you.
No installation hassles - just deploy required assembly (or assemblies).
It isn't released yet, but you can find a beta download somewhere.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Michael D. Reed said:
I have a program that uses Access DB that is distributed with the program.
I
would like to upgrade these to the SQL server that is distributed with the
program. This program needs to run as a standalone, not connected to a
server. So the SQL engine and data, log file need to be distributed with
the
EXE. I am using .NET 2.0, ADO, and VS 2005I have already converted the DB
to
the SQL 2005 and can access the structure and data using a dataset. I
have
several questions on how to do this.
MSDN talks about a MSDE, Native client, SQL Everywhere, and that SQL
Express
can be distributed.
Which client/server do I use?
Are these the same?
Can these be used by the click-once technology?
It is my understanding this was to be available in .NET 2.0 and VS2005.
Where can I get documentation how to disturbed SQL with a program?
If I am not in the correct news group please advise me which on I should
be
in.
Thank you,
Click to expand...
Click to expand...
 
Back
Top