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

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
--



.

Relevant Pages

  • Re: Synchronization
    ... i need to install the database servers in two different sites (different ... physical location connection via the internet VPN) and i need both servers ... work on a local database instead of connecting to one ... can we configure the SQL servers to be both pricipals and replicating their ...
    (microsoft.public.sqlserver.clustering)
  • Re: Building high available and high performance web sites with MS
    ... clustering is just for failover? ... Would have lets say 3 servers, ... have 3 sql servers with the same info and then a high available distributer. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Building high available and high performance web sites with MS
    ... What is the purpose of adding extra nodes past the 2 node cluster if ... Would have lets say 3 servers, ... have 3 sql servers with the same info and then a high available distributer. ... Microsoft clustering is a failover technology where a SQL instance can move ...
    (microsoft.public.sqlserver.clustering)
  • Re: Building high available and high performance web sites with MS
    ... Ok, now that I know Clustering wont solve my problem, is there another ... Would have lets say 3 servers, ... Then I assume I would need a way to make the 3 sql servers appear as one ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • sql server license on vmvare
    ... Right now 4 sql servers licenses are fine but we need to have more ... How to decide if we need enterprise edition or standard edition. ... four virtual machines or eight virtual machines. ...
    (microsoft.public.sqlserver.server)