Re: Need general guidance about deployent and database access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello B. Chernick,

In your approach, seems, the best solution would be to avoid using stored procedures, and realize all bussiness logic on component layer.
Thereby, u can cut down your DB codding and have DB scripts for creation and filling tables
for MSSQL and Access. User could choose which way user prefer to use MSSQL or Access.
U just need to exec script to create and fill appropriate DB


B> I have a program I want to turn into a shareware package. This means
B> that I have to come up with deployment simple enough for anyone to
B> use and small enough to download quickly. This program needs a
B> relatively small simple database to work and I've developed it using
B> SQL Server. I have no doubt the data structure could be replicated
B> on almost any popular db system. I think I know enough to write code
B> that would allow the program to create either a SQL Server or Access
B> db after installtion but I don't want to re-invent the wheel. (And I
B> would like to make it flexible enough so that conceivably a user
B> could create the data structure on any conventional db system and
B> hook to it.)
B> B> While I know how to program, I do not have any serious experience
B> with Dot Net program deployment. Where is a good place to discuss
B> this and does anyone have any advice or sample code they'd like to
B> share?


---
WBR,
Michael  Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not cease to be insipid." (c) Friedrich Nietzsche


.



Relevant Pages

  • RE: Replication Problem
    ... I have now changed the sample code once more a little bid in that way: ... A call to SQL Server Reconciler failed. ... Source: Merge Replication Provider ... doc-file and in the quoted url at the top of my posting. ...
    (microsoft.public.sqlserver.replication)
  • Re: Output Parameter To Global Variable (DTS)
    ... >article and used the dummy code. ... >end of the stored procedure thereby having the SP return a result set. ... Sorry, I am at a loss, as the sample code I posted previously works fine ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Replication problems
    ... I have now changed the sample code once more a little bid in that way: ... A call to SQL Server Reconciler failed. ... Source: Merge Replication Provider ... doc-file and in the quoted url at the top of my posting. ...
    (microsoft.public.sqlserver.ce)
  • Re: Upsize no longer transfers "Required" fields to Not "Allow Nulls"
    ... because we have a modern language! ... Since Jet database and SQL Server are two different type database engine and there are quite some differences, such as data types, it is almost guranteed that the "Upsizing Wizard" would leave something converted not so well. ... I have been working on upsizing an Access 2000 data structure to SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Migrating away from MS-Access
    ... running on SQL Server than as an MDB. ... the MDB data structure and deployment practices could also solve the ... With an experienced Access developer, the easiest way would be to ...
    (comp.databases.ms-access)