Re: Putting data in SQL server ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

By using linked tables and add the parameter dbSeeChanges here and there
where required (Access will tell you where you need to do so when you will
try to run the code), you can transfert your data to a SQL-Server and use it
as a backend from a MDB frontend in no time (well, a few hours is a more
exact evaluation). From there, you could build other interfaces like your
web interface while keeping the MDB frontend.

The only problem you might have might be a speed problem; as there is a
possibility that this will be slightly slower then using a MDB as the
backend. If you want to correct this problem, you might want to start
looking a things such as using Views, sql passthrough queries, ADP, unbound
forms, .NET, etc. (listed in order of increasing complexity/speed). For
updatable views, see:

http://support.microsoft.com:80/kb/q209123/

For a good point to start, see the newsgroup m.p.a.sqlupsizing,
mpa.odbcclientsvr and mpa.externaldata. For the remaining, start
searching/studying/trying.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:2238418A-47E2-45DD-A7B9-95EADD67D937@xxxxxxxxxxxxxxxx
I'm supporting a heavily used application and I'm feeling the need to move
the data into SQL server. The main reason being that we want a web
interface
to the data. To a lesser extent, because of data volume. This application
has around 100 queries and who knows how many VB-built SQL statements. I
realize these all have to be converted to stored procedures. I'm thinking
it
would not be too big a deal to do this. What other considerations are
there
regarding such a conversion?


.

Relevant Pages

  • Re: Detecting that a row has been updated.
    ... If you are on SQL 2008, I think checking out Change Tracking is worth ... Change the Legacy field. ... So that after a conversion stamp is only 1 higher than Pre_stamp. ... While the system is moving towards the new interface the number of tested ...
    (microsoft.public.sqlserver.server)
  • Re: Application, database and schema?
    ... > hardware interface for the monitoring. ... This subsystem understands how to talk to the ... > this case an RDB with a SQL interface. ...
    (comp.object)
  • RE: open a text file using sp_oamethod
    ... sp_OAGetProperty Fails on Properties From Inherited Interface ... Source: ODSOLE Extended Procedure ... When no OUTPUT parameter is supplied, ... Microsoft has confirmed this to be a problem in SQL Server 7.0. ...
    (microsoft.public.sqlserver.programming)
  • Re: code sharing for sql2k and sql-ce
    ... I think the idea of coding against an interface is perfect given what you're ... "ExecuteNonQuery", ... You should not have to put SQL in your ... > So it seams that I will have to use sql statement in source code, ...
    (microsoft.public.sqlserver.ce)
  • Re: Opinions on approach, please...
    ... Write the where clause manually, ... MOST interface, with the original COBOL ISAM access commented out above it. ... I can certainly do it with dynamic SQL and MOST can build a WHERE statement ... application is doing lengthy sequential processing, how often, in what ...
    (comp.lang.cobol)