STPL designed and developed the innovative solution to meet all the requirements of the client.
This application manages two different types of database, one for Selling and another for Listing.
One of these databases is in Ms-access format and other is in text file format. This application contains the utility program which can transfer MS-access database and text file into SQL Server.
Scripts were written to download the Ms Access database files (selling database) from the FTP server with the help of file-zilla and paste these database files in LAN development server, then run the utility Program for transferring the ms-access database(selling database) to SQL server.
Likewise to convert text file data (Listing data) into SQL server, download the text files from ftp server. The text file are opened in WordPad and uploaded.