Showing posts with label ADMINISTRATION. Show all posts
Showing posts with label ADMINISTRATION. Show all posts

Monday, March 9, 2009

dbMaestro TeamWork 3.7.3




The solution allows analysis of all database objects over time, it contains a central built-in version repository and a central cockpit for tracking and overview of all changes to the database during the entire development process.


Benefits and Features

* Create a version repository storing database-related development changes and change
history.
* Roll back to any version of your archived database objects
* Enable change management of database structure and content. 

Audit of usage – “who is doing what”. View checked in & out objects sorted by users 
or by databases .


System Requirements

dbMaestro TeamWork Server

* Operating System - Windows 2003 service pack 2
* Database - SQL Server 2005 service pack 1
* .Net framework 3

dbMaestro TeamWork Client 

* .Net framework 3
Database Version Repository

* Create a version repository storing database-related development changes and change history
* Import & export databases into and from the database version repository 
* Tag evolving changes in your database - know who did what and when 
* Roll back to any version of your archived database objects
* Undo updates to the structure and content of your database
* Analyze differences between different versions of your database
* Analyze the impact of database version changes 

Development management

* Manage and impose database related development processes.
* Support concurrent development while preventing collisions and conflicts, and preserving order and documentation.
* Enable change management of database structure and content.
* Check in & Check out database schema objects while locking unchecked objects
* Check in & Check out table content - to prevent accidental change of static, parameter or Meta-data tables
* Provide database override protection by enforcing your database resource management policy
* Prevent accidental and undocumented changes to database objects
* Identify database object dependencies in order to perform structurally complete changes
* Embedded plug-in enables linkage to your development environment - Visual Studio
* SCCI protocol support for CM software integration

Environment management

* Simplify database migration from development to production
* Simplify migration of changes from production back to development
* Enable generation of any database base line from the version repository
* Support a database build process from the repository
* Simplify troubleshooting by allowing rollbacks while restoring a malfunctioning system to an operational state

Information & Reports

* Analyze detailed overview of project development over time
* Audit of usage – “who is doing what”. View checked in & out objects sorted by users or by databases 
* View statistical usage reports 
* Receive alerts regarding updates to schema and Meta-data








Troi File Plug-in 4.0.2




                                                                        Any files stored on the rest of the computer can be accessed through the functions of the plug-in. All from within FileMaker you can:

* get the data out of files on the disk of the computer and put it in FileMaker fields
* create files anywhere on the hard disk and put data from FileMaker fields into it
* manipulate files and folders on the disk, like creating, deleting, copying, moving, renaming
* query detailed information of files: the size on disk, creation and modification dates and much more
* count the number of folders or files on a disk
* get images and the meta data (IPTC, EXIF) of those images inside your FileMaker database and write IPTC metadata too!

All functions of the plug-in can be used in a script enabling you to automate this power.








RGS-CardMaster 6.03




                                                                     This unique phonebook program manages and keep track of all your contacts, adresses, phonenumbers, fax, e-mail addresses, info...! It's a very complete address book with many powerful functions and still very EASY TO USE! Has a autodial, security, inquiry, sort options, e-mail and web support, many print-options, print preview, Currency-calculator, calendar... You can do mailmerge with MS-Word using your addresses stored in RGS-CardMaster! Export to Excel. This user friendly "phone book" has a low learning curve, but to call it just another "Phonebook" program would not do it right as it gives you the power of DBase but so much more easier that kids would manage it, and still, advanced options are there to please the power users! And yes, perhaps best of all, it's FREE!

You can always upgrade the Free Edition by making a donation if you want. You'll receive a special key that turns your copy into the Pro Edition. My thanks in advance.
Do I have to upgrade? No, the Free Edition is FREEWARE, so you you're not obligated. It does give you extra advantages as described below.

Note for all CardMaster v4.x users: all your databases and notes are 100% compatible with the new version 5!









Advanced ETL Processor 2.2.2




                                                                   Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key. Some examples of what our customers use this ETL tool for include:

Extract data from:

* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases
* Multiple DBF Files
* Any ODBC source
* MS Sql Server
* Multiple Tables

And Load it into: 

* Multiple Data Targets
* Sql scripts execution before and after loading
* Delimited or Fixed width Text file
* MS Access Database
* Microsoft Excel File
* DBF File
* ODBC Source
* Oracle 7-11G database
* SQL server 7- 2005
* ODBC source

Other tasks are
* Add Records
* Update Records
* Delete Records
* Add New and Update existing Records
* Validate Post codes, Phone numbers,TAX Codes using regular expressions
* Check Date Formats
* Check Numbers
* Split, merge Fields
* Split data and load it into diffrent tables
* Add, replace, delete strings
* Deduplicate Data
* Sort Data
* Group Data
* Summarize Data
* Pivot and UnPivot Data
* Create surrogate keys
* Translate coded values
* Derive a new calculated value
* Run Sql script before and after loading data
* Filter Source Data
* Use Select Statement as a Data Source
* Run transformation script from the command line 

If something went wrong Advanced ETL Processor writes detailed message into error log and writes a record into rejected records file.










TrafficObjects 1.0.8




Even if you are already
monitoring the data at the source elements by another means, TrafficObjects will help you verify that
the data is successfully populated in the corresponding databases.

Plot data fetched from databases such as Oracle, Postgresql, Microsoft SQL Server, Sybase,
MySQL, etc and data fetched from text files such as CSV, Tabular and Postgresql Log files.
New features:
1. View another user's views/charts within the same login session
2. Rename and delete views








SqlDbx Personal Edition 3.23




                                                                          SqlDbx built around an advanced SQL Editor and Database Object Explorer. SqlDbx provides a consistent user interface between different DBMS Systems. The intuitive and straight forward interface allows developers to improve their productivity by having easy access to the most commonly used features. Run queries, execute scripts and browse database objects without leaving editor window. SqlDbx is a standalone executable file, so no installation is necessary. Furthermore, SqlDbx does not install or modify anything on the user's computer.

Features at a glance:

* High performance native support for major Database Servers including Microsoft, Sybase ASE, Oracle and IBM DB2/UDB
* Browse / Explore Servers
* Fast, intelligent, extensive and highly customizable Intellisense
* Advanced Script Editor with Syntax highlighting, Auto Complete, Speed Typing, Script Variables, Drag/Drop, Column (Block) Mode
* Unicode support
* Visual Data and File Diff
* SQL Object Scripting
* Generate SELECT, INSERT, UPDATE, DELETE, WHERE IN data modification statements directly from Result Grid
* SQL Templates with support for formal parameters
* Import / Export to CSV, XML, Excel
* Schema Object browser
* SQL statement history
* Favorite objects. Find object
* Search in Database and in Result Grid
* Directly edit table data in Result Grid
* Sort, filter, format, export and transpose data in Result Grid
* Execute procedures and functions with automatic argument specification
* Display query plan and query statistics
* Administrative Views
* Simple deployment and removal. No dll's or other dependencies. Just one executable (1.5 meg.)

Supported DBMS Systems

* Sybase® System 10.x - 15.x
* Microsoft® SQL Server 6.5 - 2008
* Oracle® 8i - 11g
* IBM DB2® 7.x - 9.x, zOS/390 7.x - 9.x
* ODBC 3.0 compliant sources







xSQL Object 2.5.3.6




                                                                            xSQL Object is a professional grade SQL Server tool for comparing and synchronizing SQL Server databases. It allows the SQL Server developers and database administrators to keep their development, testing and production environments in sync with minimal effort. Some of the features include: 1) Full support for SQL Server 2000 and SQL Server 2005 - all objects; 2) Cross version comparison - compare a SQL Server 2000 database with a SQL Server 2005 database and generate version specific change scripts; 3) Schema snapshots - maintain a history (audit trail) of the schema changes and provide for safe and efficient reversing of schema changes when necessary; 4) Wide array of options allows for granular control of the behavior of the comparison engine; 5) Enhanced object filtering - compare and synchronize only the objects you want; 6) Comparison results displayed in an easy to read color coded grid that allows the user to drill down into the differences, view the scripts of objects, filter results and more; 7) Generate safe, standardized change scripts and review scripts before executing on the target database; 8) Command line utility provides for scheduled, unattended comparison and synchronization operations; 9) Enhanced scripting capability - script any object or the whole database, script schema only or schema and data together.
How can xSQL Object help you?


For the independent .NET / SQL Server developer: while you are pounding code on your machine you are liberally making small changes in the local database – add a column here, change a width there, add a view, make a change to a stored procedure and so on. At some point in the early morning hours as the World wakes up you are ready to publish your work on the production server, somewhere across the continent – just a few clicks and the early risers will see your masterpiece (application) in action. Well, not so fast unfortunately, all those small changes you made to the local database must be made to the production database otherwise your application is not going to work – now, that is some painful and tedious work to say the least. And here is a twist to make this a real nightmarish scenario – remember last week when the client needed those urgent changes and you were forced to do the “unthinkable” – make changes right on the production database! Worst yet, you realize that you forgot to bring those changes down to your local, development database – no words can describe the pain you must feel at that moment! Is this time for panic? No it is not, it is time for xSQL Object – in just a few clicks it will show you exactly where the differences are on both sides and better yet auto-generate the scripts that you need to quickly and safely make the changes. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.

For the member of a .NET / SQL Server development team: your DBA has “stapled” the database change rules on your forehead. You have to follow the protocol, thoroughly document the changes you are requesting, write the change scripts as well as the scripts for reversing those changes if need be. When all is ready submit the request to the DBA and keep your fingers crossed. Hopefully you did not miss anything because if you did you are in trouble – the QA team will find out and changes will be rolled back and the process will be delayed and you will be held responsible for the project delay! Even if you did not miss anything the DBA may determine that the change scripts you submitted do not follow the standards and reject them. Hours upon hours of valuable time are consumed by such tedious tasks that a developer would rather not deal with. Well, you don’t have to – xSQL Object automates the process and makes the task quick and enjoyable. You will never miss a change again, the change scripts will be standardized, well formed every time and you will be on the good side of your DBA. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.

For the SQL Server DBA: we all know you are the king of your enterprise – nothing can happen without your approval, no executive decision can overwrite your rules and decisions as no one would dare take that responsibility. Now, that is one of the great things on the life of a DBA, however with the great power vested on you comes great responsibility. The database you control is the heart of any modern organization - if it malfunctions the enterprise will be put at a great risk. You must be meticulous, establish strict rules for managing the database and carefully control and monitor any schema changes - keep track and be able to reverse changes at a moment’s notice. On top of all this you have to deal with those hard to discipline developers that are not following the strict guidelines you have put in place – you have to review change scripts written by this diverse group of developers each of them with his/her unique “style” of coding. Wouldn’t it be nice if you could effortlessly maintain a complete history of schema changes and be able to point exactly what changes happened when? Wouldn’t it be nice if you could schedule a job that runs periodically and tells you whenever something changes? Wouldn’t it be great if you could automatically generate scripts that are inherently safe? You can get those and more with xSQL Object and xSQL Command Line Utility. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.








tmWorks R-View 1.7.0




                                                                         tmWorks R-View is a full featured web based database administration and database driven application building tool for the JDBC enabled databases.

With its web based intuitive interface, you can create or modify database, table, index, procedure, function and many other database administration task via almost all browsers.

Visually rich and intuitive web based table data editor enables working with data as easy as using a spreadsheet;

Web based form builder and query builder help you create database driven application like search form, chart report easily. with these applications,non-technical people can work with database like experienced IT staff.

Theoretically, tmWorks R-View supports almost all databases such as MySql, SQL Server,Oracle, Sysbase, Db2, PostgreSQL on almost platform such as Windows, Linux and Mac.








SQL Stripes Enterprise 2008 2.8 Build 900




                                                                SQL Stripes includes numerous features. Here are some major key features, along with a quick explanation:
u "Nothing But SQL"
First and foremost - SQL Stripes uses nothing but SQL Server Protocol to communicate and query the SQL Servers which are being used / monitored. This means that nor firewall compromise neither special network settings are required in order to work with SQL Stripes
u All-in-one Management & Control Console
Managing an environment with multiple SQL Servers becomes an easy task. SQL Stripes gives you the ability to quickly get to any part/object/definitions/status/remote access on your SQL Servers.
u Instant ("Agent-less") Monitoring
The need to install an "Agent" component on each monitored server was always a pain; From the need to install software on each Server - to the fact that you have an additional process which uses resources and can impact the other running software on your production server. SQL Stripes monitors SQL Servers without any installation required. This also means minimum to none performance impact on the monitored servers.
u Search on Multiple Servers
SQL Stripes has the ability to search for objects on multiple servers such as job, user, stored-procedure text, tables views, columns and more...
This unique feature if very useful on a multiple servers environment
u T-SQL Execute on Multiple Servers
Execute any query, stored procedure and more on many servers all at once!
[NEW!] Furthermore - get all results into a single grid and have the ability to export the results.
u Integration with SQL Server Tools
One of our main motto is "integrate instead of reinventing the wheel".
SQL Stripes has strong integration with Query Analyzer, Profiler, Management Studio, 3rd party Remote Access software and more. You can connect to each within a single-click while automatically being connected to your selected server.
[NEW!] With the new version of SQL Stripes, it is possible to create custom integrations with any desired application
u Access anywhere on the Enterprise
[NEW!] SQL Stripes has a powerful repository which stores all of its data. This repository can be stored on ANY SQL Server and be shared in real-time with other instances of SQL Stripes.
u Notifications
SQL Stripes supports various ways of notifying you on alerts. Notifications include: Email, Realtime-updated HTML (for remote view), Sound & Speech Alerts (you can have your computer speak out the recent problems & recoveries) and more...
u From DBAs, To DBAs
Forget about those generic monitoring tools! SQL Stripes is all about fit like a glove to SQL Server DBA's. This is our main objective & focus. Throughout the entire writing process we've been working closely with many DBAs and many of their requests are inside SQL Stripes as features today. We believe that this is what makes SQL Stripes better
What's New:
u Added UDA - User Defined Applications - allowing the user to define & integrate his own applications
u Added Remote/Shared Repository support - Repository can be stored on an SQL Server and accessed from various instances anywhere
u Added new Hotkeys for ease of access: F12 for "More" button, Ctrl-F5 for Internal T-SQL Editor
u Repository Enhancements
u Repository Database Schema updates
u Improved Help
u Improved T-SQL Viewer window syntax Highlighter
u Added an option to see the highest CPU-Consuming process (within SQL Server)
u Fixed a minor bug involving extra bracket when viewing a table with Query-Analyzer
u Fixed other various minor bugs








ContactKeeper 1.4.2




                                                            ContactKeeper is a free personal information manager with an integrated birthday reminder, who keeps you informed about upcoming birthdays.

ContactKeeper is consciously very flexible and simple, there are only a few fields, in the course of which an unlimited quantity of numbers and e-mail addresses can be stored for each person, extra information can be put in the note field.

The most important functions of ContactKeeper are the birthday calendar, quick and easy navigation, an extensive search function, export to (x)html or to a text file and of course the birthday reminder.








Sunday, March 8, 2009

Navicat for MySQL 8.0.28




                                                     Navicat is a powerful MySQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users. With an user-friendly GUI, Navicat lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple MySQL server connections which can be connected locally or remotely. Your remote MySQL server can be running on Linux, Unix, Mac OS X or Windows platform.

Features:

# Supports all MySQL versions
# Supports MySQL Event, Views, Triggers and Stored Procedure creation
# Supports Unicode / Character Set
# Supports HTTP Tunnel and SSH Tunnel
# Supports Foreign Key for InnoDB Tables
# Supports Foreign Key Data Selection
# Form View 

# Print Table Structure
# Virtual Grouping
# Visual Query Builder - create query from different databases
# Code-Completion for Query, View and Event 

# SQL Console
# MySQL Views Builder
# Import data from ODBC
# Import Oracle to MySQL
# Import MS SQL to MySQL
# Import data up to18 most popular formats including MS Access, MS Excel, XML, PDF and TXT
# Export Data to MS Access / MS Excel
# Export Data to different file formats: MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc
# Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization
# Send notification e-mail for schedule task
# Supports Backup and Restore MySQL databases
# Supports Data Transfer between local / remote MySQL databases
# Data and Structure Synchronization
# Create Reports with visual Report Builder
# Export Report to multiple formats, PDF, Excel, HTML etc. 

# View Reports with Report Viewer 

# Visual User Manager
# Server Monitor









L.C.KAHADUGODA

YOU ARE WELCOME TO MY SITE

whos.amung.us - visitor maps