Friday, February 11, 2011

Calling SQL Server With A BlackBerry Phones

This article provides a simple Web page to play multimedia files on a home computer using a BlackBerry phone. It does this by using SQL Server to store selected binary images (documents, music, videos, etc.) bulk copied to it. Such images may be opened on a smart phone, copied to other SQL Servers, or downloaded to remote machines.

Sunday, February 6, 2011

EMS SQL Management Studio for SQL Server

Compatible with Windows 7EMS SQL Management Studio 2010 for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for MSSQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for SQL Server in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing SQL Server database administrators and SQL Server application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!

Tuesday, February 1, 2011

Advanced Intellisense for SQL Server developers & DBAs

SQL Complete: smart autocomplete for SQL Server developers & DBAs

dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code.

Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

Key Features

Context-based code completion
SQL Complete thoroughly defines the context to predict what you want to type next. Smart intellisense prompts only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.
Parameter Info
When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint. Get the necessary information promptly without browsing external documentation.
Customizable SQL formatting
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.

Thursday, December 16, 2010

Visual Query Builder for SQL Server

for visual creation of any queries without code typing. Lots of innovative options for extended query results management...

Building SQL queries is easier with a visual query builder. FlySpeed SQL Query allows new and professional database developers to build complex SQL queries in a simple graphical manner.
The main component of Query Builder is a visual diagram where you can "draw" your query.
Compatible with multiple types of databases, FlySpeed SQL Query can perform queries on different database servers without requiring knowledge of SQL. Viewing, analyzing and summarizing the results is also easy thanks to the ability to print the results or export data.

Saturday, December 11, 2010

Access to SQL server. Access to MS SQL.

How to Migrate from Access to SQL Server 

DBConvert for AccessMSSQL with scheduler converts MS Access (mdb) database to MS SQL Server and MSSQL to Access database
You can save resulted data to MSSQL Dump file that allows you to get over the restrictions on access to MS SQL server if any.

DBConvert for Access & MS SQL is a reliable bi-directional database migration tool which allows you to convert from:
  • MS Access to MS SQL
  • MS Access to MS Access
  • MS Access to MS SQL Dump
  • MS SQL to MS Access
  • MS SQL to MS SQL
  • MS SQL to MS SQL Dump
  • MS Access queries to MS SQL views 
Convert databases from MS Access to MS SQL or from MS SQL to MS Access rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simple configuring of several options through Wizard interface or in command line mode! DBConvert for Access & MS SQL is also applicable for MS SQL database migration to another MS SQL database or to another MS SQL Server. Moreover, DBConvert for MS Access & MS SQL is quite well for copying MS Access database (.mdb/.accdb) to another MS Access database (.mdb/.accdb). 

Thursday, December 9, 2010

Review Data Export for SQL server

FlySpeed Data Export

The Universal Database Export Tool

FlySpeed Data Export is the must-have tool to export data from your database quickly and easily. The ability to export data from almost any database using OLE DB or ODBC, and save data to the most-popular office formats makes FlySpeed Data Export a really universal data export tool.

Data extraction from direct connections, OLE DB or ODBC data sources

  • Direct connection to MS SQL ServerOracle and MySQL source databases.
  • Direct connection to MS Access source databases. *
  • OLE DB and ODBC connection to PostgreSQLInterBaseFirebirdDB2InformixSybase and other data sources. *
  • Data extraction from desktop databases ParadoxFoxProdBase (DBF) through ODBC. *
  • New: Exporting data using native Oracle Export and mysqldump utilities.
free download

FlySpeed Data Export was successfully tested with all popular database servers, such as MySQL, Oracle, MS SQL Server, PostgreSQL, Firebird and many others. The tool lets you to save data in MS Excel, CSV, HTML, XML, DBF, Text, MS Word, MS Access, Open Document Text and Spreadsheet formats.

Data export to many popular office formats

  • Export to MS Excel spreadsheets.
  • Export to CSV (Comma-separated values) files.
  • Export to Text (Space delimited columns) files.
  • Export to MS Word and RTF documents.
  • New: Export to Open Document Text and Spreadsheet.
  • New: Export to OpenXML format (readable by MS Excel 2007 and MS Word 2007).
  • Export to XML files.
  • Export to HTML web pages.
  • Export to MS Access database.
  • Export to dBase (DBF) tables.
  • Exporting BLOB field values to files.

free download

The Essential Tool for Everyday Data Transfer

FlySpeed Data Export is not a one-time utility, but a set of Power Tools to automate your data export tasks. Saving all export settings to a file, you may easily repeat your task in a few mouse clicks. The Command-line tool and the Task Scheduler let you automate your data transfer completely.

Feature List

  • Working in the background, hiding into the system tray.
  • Allows flexible scheduling of transfer project execution.
  • Saving a detailed log file for each execution.

free download

The Free Tool to Export Your Data

Wednesday, December 8, 2010

Review FlySpeed Database Migration Tools

Database migration under control
FlySpeed DB Migrate is a timesaver for database migration and data transfer tasks. It successfully copes with the two main problems occured during migration from one database server to another:
  • Full transfer of the database tables structure and data in regards to all the fine points of the destination database server
  • Data transfer into already existing tables with ability to maintain data actuality afterwards (single-side synchronization).

The tool to move your database from one server to another

FlySpeed DB Migrate provides rapid data migration across databases ensuring lossless data integrity. It allows modification of a database structure and data with ease. With FlySpeed DB Migrate, you gain the control you need during the migration process.

The tool for everyday data transfer

FlySpeed DB Migrate is not a one-time utility but a set of Power Tools to automate your data movement and synchronization tasks. Saving all migration options to a file, you may easily repeat your task in a few mouse clicks. The Command-line tool and the Task Scheduler let you automate your data transfer completely.

FlySpeed DB Migrate Key Features

  • Complete or partial transfer of database schema and data.
  • Restructure/Transform schema and data with ease during migration.
  • Transfer data into existing tables within the destination database.
  • Transfer new/updated/deleted records only (single-sided data synchronization).
  • Generation of SQL Script (Dump) for future execution on the destination database server.
  • Running data synchronization tasks in one click using the Command-line tool.
  • Full automation of migration process with the Task Scheduler and OLE Automation.
  • Full monitoring and control over the database generation process.
  • Full Unicode support.

Buy now Download White paper