Re: MS SQL -> ACcess Data Export (Nearly 2 000 000)

SEDS wrote:

We will collect 100+ MS SQL servers data in one central server. Local
Servers are not allowed to acces internet. Local users can not
execute
simple task on computers. They dont have enough knowledge about
computers. So I have to write simple app. for exporting data. Is
there any DTS app. example?

Thanks


"Graham Harris" <ng@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:446f582f@xxxxxxxxxxxxxxxxxxxxxxxxx
> SEDS wrote:
>
> > Hello,
> > I have to export jobs from MSSQL server database to access
database. > > Nearly 2 000 000 datas have to be exported. This
operation will be > > done over 100 MS SQL Server. I am using Delphi
6. When I try to run > > the program it gives "virtual memory not
enough". error. Is there Any > > idea?
> >
> > Thanks,
> >
> Don't use MS Access. If memory servers MS Access is only suitable
> for small databases, as the first job I had was to generate
> reports from within MS Access this then had to be run over night
> and with a bit of luck I would have the finished report the next
> morning.
>
> Why do you need to export the data to MS Access?
>
> HTH
>
> Graham Harris
> --
>

Cann't you use SQL Server replication i.e. a Server inside the network
that is allowed to replicate the data from the remote servers into
individual databases, which access can be limited to by the use of NT
Authentication or by SQL Server authentication with each user account
linked to a database, and then your app connects to that server?

Graham Harris

--

.

Relevant Pages

  • Re: Prolog on a web server
    ... thrilled if you wanted to load it all into server VM:-/ ... rapidly build yourself a desktop app (Delphi? ... As for Prolog, it could surely be the basis of a decent ... grown-up database query language (an open standard dialect ...
    (comp.lang.prolog)
  • Re: Python Database Apps
    ... It's gonna be a desktop app. ... so that I don't need a database server on the client side. ... If you have an offline mode then the most important thing to work out ...
    (comp.lang.python)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.access.replication)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.vb.com)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.inetserver.asp.db)