Vishal Gupta said:
thnx guys for ur replies
Suppose I hv copied my all JSP files in following folder:
D:\Vishal\anou\
And I hv created a backup of the database and now I hv also copied the backup file in:
D:\Vishal\
And also copied Web server setup file in:
D:\Vishal\
Now what to do? I'm very new for this
How to create SQL scripts?
From where to copy the ODBC data source?
Pls post a step-by-step procedure.
How to create SQL scripts? (and then u say u've made this project (LOL))
sql scripts are the text which you fire in sql server Query Analyser
1. -----------How to create SQL scripts?---------------
First make the script of the database (you need to install the sql server at the testing pc initially) then for the tables involved and then the data insertion one
their skeleton are like
Your whole Script should lool like
CREATE DATABASE database_name
[ON {[PRIMARY]
(NAME = logical_name,
FILENAME ='physical_name'
[,SIZE = size]
[,MAXSIZE = max_size | UNLIMITED]
[,FILEGROWTH = growth_increment])
}[,...n]]
[LOG ON
{(NAME = logical_name,
FILENAME = 'physical_name'
[,SIZE=size | UNLIMITED]
[,MAXSIZE = max_size | UNLIMITED]
[,FILEGROWTH = growth_increment])}
use <database name>
for tables
Create table sonu
(ser numeric,
name varchar2(35));
for data insertion
Insert into sonu values (001,'Sonu yadav')
--------------------------------------------------------------------------------------------------------------
or simply export the database of your in access format and then import it at the testing computer. (this you have to do manually)
2. From where to copy the ODBC data source?
dsn files are with extension .dsn and are placed in
"c:\program files\common files\odbc\data sources"
first make a "file dsn" then copy it from here.
lets say your folder look like
d:
vishal
setup 'for web server setup'
jsp 'for all jsp files'
odbc 'for the odbc file'
scripts 'for sql script'
Place a bat file in your folder "Vishal"
now edit it to read somewhat like this
@cd \
@cd d:\vishal
@cd d:
@cd vishal
@cd setup
@echo "Installing Web Server Please wail for its completion"
@<webserversetup.exe>
@echo "After Web Server Installation is complete Press any Key for next Step"
@pause
@echo "Starting your Webserver"
@Start <your web Server startup link (its default)>
@cd ..
@echo "Press any Key after web server is started"
@cd jsp
@echo "copying Files to the server root directory"
@copy *.* <default root of your web server>
@Press any key after the files are copied to the root"
@pause;
@cd ..
@cd odbc
@echo "copying the DSN"
@copy <dsnname>.dsn "c:\program files\common files\odbc\data sources"
@echo "press any key to continue after the DSN file is copied"
@pause;
@cd .. 'Optional Better to do it manually
@cd scripts 'Optional Better to do it manually
@osql /Usa/Psa @script.sql 'Optional Better to do it manually
@echo "Setup complete"
for manually preparing the backend import the access file (which you made earlier by exporting the database at your place)
at the testing site
now you can either use this folder as setup or make a sfx of it
