PDA

View Full Version : SQL update or... with zip file.



parachute
11-05-2003, 10:58 AM
Hi !

I'm working with IS 7.04 and the new project I have is to upgrade file in the client/server application.

I have an SQL database and I have 2 files. One containing the name of the database and the next is the zip file where I have to add the content of the zip in the database. First, I have to check if the database exists. If it doesn't, I have to create it and add files. If it exists, I have to verify the version of the file before add it or modify it. I'm just totally lost !

Is IS is good for or I need to write another thing that IS can use after ? Is IS is able to unzip file ?

The name of the database will be included in the name file. Ie. the name can be CAN_V1_1_2 where CAN is the database name.

Thank you !

Lucos2002
11-06-2003, 07:35 AM
Hi!

What kind of database are you runnig? If it is MSDE then I might help you.
Anyway the best thing to do for you would be create one sql script that does everything for you.
Any SQL scripting skill?

parachute
11-06-2003, 09:52 AM
Hi !

The database is SQL Server 2000 and yes, I have skills with SQL scripting.

Thank you !

kk sonu
11-20-2003, 04:28 AM
go to www.installsite.org
and in database section u can find all the functionality related to database

hope ur problem will be solved

all the best
kk