SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Automating import from another apps into SQL 2

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Automating import from another apps into SQL 2
Author Message
Pious



Joined: 17 Apr 2003
Posts: 2

Post Automating import from another apps into SQL 2k Reply with quote

I am a Network administrator for a computer sales company and a novice in SQL 2000 database. I have been able to singlehandedly installed SQL server 2000 on a Windows 2000 Advanced server. My office uses a Sage line 50 accounting software and Maximiser 7 to track and close more sales (on the Advanced Server). I need to integrate it ino this SQL server by importing/exporting files to/from the database of the Sage server/SQL server. I am thinking of writing a script to automate this process, to provide me with links to back-end corporate database (in this case my SQL server) to allow users to run their own reports and upload data for use by other departments and applications and share corporate data please if this is possible can you help me out with this? I would be grateful if you can be of help or any useful site I can get the information I want.
Thanks regards
Pious

Thu Apr 17, 2003 12:32 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: Automating import from another apps into SQL 2 Reply with quote

SQL Server supports complete set of utilities for managing file import/export, scheduling this processing, making reports and so on. They are called Data Transformation Services (DTS). Virtually any data processing can be automated if you know T-SQL, VBScript or JavaScript You can find out more about DTS please read your SQL server documentation or browse the internet.
For more info please see http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=sql+server+dts

By the way, this message forum is dedicated to support SoftTree Technologies' database tools.

: I am a Network administrator for a computer sales company and a novice in SQL
: 2000 database. I have been able to singlehandedly installed SQL server
: 2000 on a Windows 2000 Advanced server. My office uses a Sage line 50
: accounting software and Maximiser 7 to track and close more sales (on the
: Advanced Server). I need to integrate it ino this SQL server by
: importing/exporting files to/from the database of the Sage server/SQL
: server. I am thinking of writing a script to automate this process, to
: provide me with links to back-end corporate database (in this case my SQL
: server) to allow users to run their own reports and upload data for use by
: other departments and applications and share corporate data please if this
: is possible can you help me out with this? I would be grateful if you can
: be of help or any useful site I can get the information I want.
: Thanks regards
: Pious

Thu Apr 17, 2003 2:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.