OpSQLPInst ... SQL-Server-Project-Install
 Description Screenshots VersionHistory Requirements Download
Description:
OpSQLPInst is a Tool to Manage Objects (Stored Procedures) on different MS-SQLServer (e.g.: Development and Production).
Upsize .DBF and .MDB Tables to MS-SQLServer.

Prepare your Project:
1. Save your original Stored Procedure to a TextFile (sp_demo.txt).
2. Define one ore more new SQLServer with DisplayName, Server, DB, User, Password, More...(e.g.: Network=DBNMPNTW or Network=DBMSSOCN) and TimeOut. Save the SQLServer-Set.
   
3. Define a new Project with a Name (Demo) and a ProjectFile (prjDemo.ini). Save the Project. Refresh and select it.
   
4. Define a new Project-Step with a Name (sp_demo) and a SrcFile (sp_demo.txt) and the Type (='P') and sysstat (& 0xf = 4). In the DoBefore you can define a Action that you need, before the Stored Procedure is created (e.g.: drop table demo). Save the Project-Step. Refresh and select it.
   

Now you can Work:
1. Connect to a SQLServer
2. Select a Project.
3. Go to Project-Step and select a Step.
4. Refresh the DB-List and select a DB
   
5. Now you can Check if the Stored Procedure exists,
   or Display the Stored Procedure,
   or Compare the Stored Procedure with the TextFile,
   or Create the Stored Procedure from the TextFile.
   

Import:
Import-Project:
   
Import-Step:
   


Features:
* Connecting to predefined MS-SQLServer
* Stored Procedures: Check, Display, Compare, Create
* Tested with MS-SQLServer 7.0, 2000
* Data are stored in TextFiles and .ini-Files and not in the Registry, so you can transport the Data easy.
* Import: Create Structure, Upsize Data, Compare the Structure
* Upsize .DBF-Files, Define the SQL-Types for System/Project/User
* Upsize .MDB-Files
* Compare the Structure of the Source(.dbf,.mdb) with the Destionation(SQL-Server)


Screenshots:
OpSQLPInst

VersionHistory:
1.07 (2003.12) Latest Version
1.06 (2003.12) New: with Import .mdb, New: Compare the Structure
1.05 (2003.12) New: with Import .dbf, New: exclude Tables, New: PreCopy Copy2.dbf
1.00 (2003.10) First Version

Requirements:

Download:
Link zum Download

Send your Feedback to OpSoftware@chello.at

 © 2000-2003 Ing. Otmar Pilgerstorfer