|
|
Posted by samuelhon on 11/16/06 11:40
Hi Ted
I dont know enough about your situation to make a suggestion yet. A
couple of questions from me:
Why do you need to use Access if you're going to install SQL Server
Express?
Is this a client requirement?
Is there alot of information? Could you use XML?
Not sure Jet is actually included with XP, think you have to install
it.
With regards to your second question, I'm afraid I dont know. I do
remember Access having a subset of commands, not sure about the latest
versions
Sam
Ted wrote:
> Hi Sam,
>
> My first question is this: "If you were in my place, and wanted to
> simplify deployment, would you use some of the ADO.NET classes to copy
> the MS Access database to SQL Server, and then deploy SQL Server 2005
> Express with your application, or use the Jet engine for both the
> existing Access database and the new recipe database, or leave the
> Access database as it is and create a SQL Server Express database for
> the new database?"
>
> I ask this first because a) I don't have Access so working with an
> Access database is a PITA except within my Visual Studio 2005
> application projects, b) IIRC the Jet engine is included with all
> recent versions of Windows (at least the ones I'll support), and c)
> based on my reading, I can deploy the SQL Server 2005 Express with my
> application (or is this necessary - am I mistaken in assuming the SQL
> Server 2005 Express is not included in the latest versions of Windows)
>
> A second question is this: "Is the dialect of SQL used by Access the
> same as that used by SQL Server 2005?" In other words, can I create a
> DDL SQL script in SQL Server 2005's Management Studio that will create
> my recipe database and then use ADO.NET 2 or ADO.NET 3 to submit it to
> the Jet engine, along with a file name ending in mdb and have the
> application properly create a NEW Access database? I ask because, with
> my current suite of tools, it is trivially easy to create my new
> database in SQL Server (and in a form entirely supported by the
> capabilities of SQL Server Express - this db doesn't need the
> capabilities in the other editions of SQL Server), but I am concerned
> about how to deploy it or to make a distribution that will install
> everything my application requires on a new machine (or a client's
> machine). When I bought Visual Studio v6 oh so many eons ago, it came
> with a utility for building distribution images that could be placed on
> floppies of CDs, but I can't find the counterpart for Visual Studio
> 2005.
>
> Thanks
>
> Ted.
Navigation:
[Reply to this message]
|