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

Friday, March 12, 2010

How to migrate databases of different SQL Server versions

Need to move databases from SQL Server 2000 to SQL Server 2005 – 2008 or vice versa?
dbForge Schema Comparer for SQL Server can successfully do any of these tasks. This tool generates a script in the same syntax that is used by the Target database. For example, if the Target database is on SQL Server 2000, User-Defined Data Type in the script will be written like EXEC sp_addtype ‘State’, ‘bit’, ‘NOT NULL’, whereas for SQL Server 2005-2008, it could be CREATE TYPE dbo.[State] FROM bit NOT NULL.
Different syntax:

Thursday, March 11, 2010

Ensuring Quality of dbForge Schema Compare for SQL Server, v 2.0

The most important characteristic of any software is its quality. The quality, according to the model specified in the ISO 9126 standard, consists of the following characteristics:
  • Functionality
  • Reliability
  • Ease of use
  • Efficiency
  • Maintenance
  • Portability
Of course users are not concerned about any quality models and just tell us their suggestions and wishes. It’s these suggestions and wishes that are the most preferred description of any quality characteristic.
Below we give the list of main aspects we paid special attention to when developing dbForge Schema Compare for SQL Server in order to deliver software of the highest quality to our users.
  • Dependencies. One of the key difficulties during object synchronization is caused by dependencies between objects and inside them. These dependencies are built basing on the information received from the server, but frequently there is not enough of it. To simplify the situation, we’ve implemented and tested a parser that looks for missing dependencies. Owing to the parser, all existing dependencies between database objects are found.

Wednesday, March 3, 2010

EMS SQL Manager for SQL Server

EMS SQL Manager for SQL Server is a high performance tool for Microsoft SQL Server database development and administration. SQL Manager works with any MS SQL Server versions from 7 to the newest one and supports the latest SQL Server features including new data types (datetimeoffset, hierarchyid, geometry, geography and more), table types and table-valued parameters, logon triggers, backups with compression and other. It offers plenty of powerful SQL tools such as Visual Database Designer that allows creating SQL Server database in few clicks, Visual Query Builder and advanced SQL editor to build complicated SQL Server queries and many more useful features for efficient SQL Server administration. SQL Manager for SQL Server has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Key Features

  • Support of SQL Server 2008
  • Support of Unicode data
  • Rapid database management and navigation
  • Easy management of all SQL Server objects
  • Advanced data manipulation tools
  • Effective security management
  • Excellent visual and text tools for query building
  • Impressive data export and import capabilities
  • Visual Database Designer to handle database structure in a few clicks
  • Easy-to-use wizards performing SQL Server administrative tasks
  • Powerful tools to make your work with SQL Server as easy as it can be
  • Report designer with clear in use report construction wizard
  • New state-of-the-art graphical user interface

MS SQL Maestro is a powerful Windows GUI solution for Microsoft SQL server administration and database development

MS 
SQL Maestro MS SQL Maestro  is the premier GUI admin tool for Microsoft SQL Server and MSDE management, control and development. Key features include:
  • Support for all Microsoft SQL Server versions from 7.0 to 2008
  • Easy database object management
  • Database Designer
  • Comfortable access to SQL server security features
  • Data management: editing, grouping, sorting and filtering abilities
  • Handy SQL Editor with code folding and multi-threading
  • Visual Query Builder with support for subqueries and UNIONS
  • Data export/import to/from the most popular formats
  • Powerful BLOB Viewer/Editor
The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.
Easy installation and intuitive interface in combination with support of all the SQL Server latest features up to version 2008 make it an irreplaceable tool for MS SQL Server on the web or at your local desktop.

MS SQL Schema Comparison

What schema comparison and synchronization tool do you need?

Anything able to compare and synchronize database schemas or packed with extended functionality? Want clear schema differences and safe database synchronization? Search for a stable SQL Server schema compare tool? 

dbForge Schema Compare for SQL Server delivers!

  • Rich features set
  • Best bang for your buck
  • Remarkable customer support
  • Standard and Professional editions
  • 30-day fully functional trial!
  • Free 1-year subscription for updates

Tuesday, March 2, 2010

SQL Tools Blog. WEB hosting SQL, ASP no MONEY?

Hello World!
How get web hosting asp free
How get web hosting SQL free