| |
| ** COMSQL Closing **
(FOR CURRENT FINANCIAL YEAR 01-04-2007 to 31-03-2008 ) |
| |
| |
| Step 1: Check
Free Disk Space On Drive Where Sqlbase Server Is Installed. Free Space
Must Be Approx. Twice Of Current Database i.e DBS File Size. |
| Step 2: If
Available Disk Space Is Sufficient. Run Check Database From Program
Utilities Menu. |
| Step 3: If
Database Check Is Successful. Take Database Backup. |
Step 4: Go To
SQL850 Folder
Create New Folder With New Database Name (eg. COM0708 ) And Unzip,
Uncompress Backup Taken In Step 3).
Server Must Be Closed During This Operation. |
| Step 5: Rename
Old Year Database DBS File To New Year Database Name i e Same As Folder
Name Created In Previous Step (eg. COMSQL.DBS TO COM0708.DBS). |
Step 6:
A
(1)
Edit Sql.ini File In Sqlbase Folder.
Find Block [dbnt1sv]
dbname=comsql,sqlws32
dbname=com0708,sqlw32
(add this line in small alphabets)
(2) Copy this sql.ini To Comsql folder also |
| Step 7:
Download & Run SCOMCLOSE.EXE From COMSQL FOLDER
SCOMCLOSE.EXE
,
SDBEXPLORER |
Step 8: (a)
Select Database Name COMSQL.
(b)Enter New Financial Year Start & End Dates.
(eg. Current Fin. Year From: 01/04/2007 Current Fin. Year To:
31/03/2008).
(e)Un-Check 'Op Balance To Be Carried Forward' Check Box If Financial
Are Not To Be Carried In New Financial Year i.e Opening Balances To Be
Entered Manually In New Year. |
| Step 9:
This Process Will Take Time Depending on
Database Size. Closing Will Be Completed After Successful Message. |
Step 10. Run
Program File COMSQL.EXE Go To Utilities/System File Maintenance
And Change Financial Year In Both The Databases Old & New. |
| Step 11 : For
Backup In Comback folder edit file COM0708.bat and type the following
lines:- @ echo off
cls
del data10.zip
ren data9.zip data10.zip
ren data8.zip data9.zip
ren data7.zip data8.zip
ren data6.zip data7.zip
ren data5.zip data6.zip
ren data4.zip data5.zip
ren data3.zip data4.zip
ren data2.zip data3.zip
ren data1.zip data2.zip
ren com0708.zip data1.zip
pkzip com0708 E:\sql850\COMSQL\com0708.dbs E:\sql850\com0708\*.log
(if sql850 folder is on E:\ or specify another drive)
pkunzip -t com0708
cd\
Save File & Make a Shot-Cut on Desktop |
| |
| |
| |
|
|
