Lions Bay Consulting

CHOOSE YOUR TECHNOLOGY

We offer a wide range of technical expertise, from website maintenance and SEO to providing technical support during company acquisitions, database re-design and fixing, and SaaS app development.

Our specialties include:

Website updates and management, page validations, error and link integrity checks.
SEO services to improve the visibility of your website in search engines.
AI-generated art images to make your website stand out.
Application creation and architectural services.
Database design and data merge/migration, as well as data transfer (export/import) between different systems.
Technical support and expertise during company acquisitions.

OUR RATES

We have a variety of contracting options to suit your needs, from hourly rates to long-term options for clients who would like to have us on call whenever they need help. Please note that clients on long-term retainers or monthly contracts have priority over clients with short-term contracts.

Our hourly rate is $75 per hour for contracts under 40 hours. Please contact us for a quote if you estimate that you require more than 40 hours of support/development.

Monthly rates are as follows:

hours per month	price	discount from hourly rate
10	$675	10%
15	$955	15%
20	$1195	20%
30	$1685	25%
40	$1950	35%

You can pause monthly support at any time, and you can cancel it with a 3-business day notice.

We are flexible and will be able to accommodate your needs, whatever they may be. Please don't hesitate to contact us for a quote. No job is too big or too small.

SchemaVersion

SchemaVersion is an SQL development tool designed to help you store a SQL database schema in any file-based version control system (such as SourceSafe, Mercurial, Git, etc.) Simply download the schema into files and put them under the version control system of your choice.

FEATURES

Easy and fast download of a database schema
(tables, triggers, views, functions, stored procedures.)

Tracking of schema file changes.

One click generation of update scripts (see Limitations below.)

Ability to upload changes directly to the database.

HOW TO USE

Hold your mouse over a toolbar button for a pop-up description.
Click on a column header to sort results.
If you specify a path for an editor and WinMerge in Tools->Options->Application, then double-clicking on the item will open the editor or WinMerge (if a file has changes.)
To generate an update script, select all the items you want to be included in the script and click the ‘script to clipboard’ button. The script header and footer from the project options page will be applied to the resulting script.

LIMITATIONS

At the moment it is not possible to push a table to the server. You need to script the table, modify script for your needs and run it on the server.
Server validation of stored procedures and functions can give false positive.
Tested on Windows 7 with MS SQL Server 2008 R2 only. We would appreciate any feedback regarding other versions of Windows/Sql Server.