|
|
Home
> Business > Database > SQL-Script Replicator |
| |
Author : |
|
Micrologics |
|
ScreenShot : |
|
Not Available
|
|
| |
License : |
|
Freeware |
|
Operating Systems : |
|
9x XP 2000 |
|
| |
Date : |
|
2008-03-11 |
|
Price : |
|
$0.00 |
|
| |
Size : |
|
927kb |
|
Free Download : |
|
Download
Here |
|
|
| |
|
|
| |
SQL-Script Replicator Description |
|
| |
SQL-Script Replicator (SSR) is a utility that allows multiple SQL scripts to be applied to one or more SQL database's. These scripts are applied using the standard scripting utilities that ship with the respective database's. Whilst these utilities do allow scripts to be applied across different database's, it involves using command lines and batch files and is usually fairly time consuming. SQL-Script Replicator automates this process, drastically reducing the time required to perform this laborious task.
To connect to a SQL database and apply scripts, four pieces of information are required. They are the server, database & user name and a password. With this in mind, SSR was designed to work in conjunction with any ODBC data sources that may have already been setup (as they should contain most, if not all of these details). Whilst the scripts are not applied using ODBC, SSR extracts the required details from the ODBC data source and use's them to open the scripting utility, connect to the database & apply the scripts. If you do not have any ODBC data sources configured (ie: you use ADO to connect) then SSR allows you to create your own a user defined data sources.
When using ODBC data sources, some of the required details may not have been defined (for example, SQL Server data sources do not store the password). In these cases, you can use SSR to edit the data source and enter any missing information. In effect you are using SSR to 'fill in' the gaps. SSR will not edit the ODBC data source itself, but will store these extra details separately.
SSR will also allow you to define a default database, user name and password. If details are missing from the ODBC data source (as described above) and you have not specified the details in SSR, then these defaults are applied to fill in the missing gaps. This saves the time consuming task of having to change, for example, the password should you change it on a regular basis. |
|
| |
|
|
|
|