|
|
mssqlXpress
mssqlXpress is the latest full-featured integrated development environment (IDE) for MS SQL. You can develop your databases using one powerful application. If you are an MS SQL developer, your life could be a lot easier from now on!
THE PROBLEM:
MS SQL developers complain about the limited features of Query Analyser and Enterprise Manager:
--I can never remember the names of tables, fields and variables.
--I have to keep typing the same blocks of code and can't remember where to copy it from.
--I had to do a small operation to 50 procedures. Repeating all of the keystrokes really drove me crazy.
--It is annoying to have to switch between two applications all the time and only have one editing window!
--How can I test this code without damaging the database?
--Where can I keep my housekeeping code snippets?
--Using Visual SourceSafe is so tedious that I can't guarantee that my developers will use it every time. Losing version control could be a nightmare.
THE SOLUTION:
mssqlXpress has an answer for all of these problems:
Managing versions:
--View and switch back to any version of any object
--Instantly connect to Microsoft Visual SourceSafe and other Major Source Control Software
Creating and testing code:
--Execute an object or a block of code from the editor and then undo
--Store your informal scripts (code snippets) with the database project
--Write procedures without needing to DROP
Editing with great time-saving features:
--Pick table, field and variable names from 'intellisense' lists as you type
--Edit objects using multiple windows
--Drag and drop or copy and paste code between windows
--Instantly duplicate an object
--Insert blocks of code or templates using short names ('Auto-complete')
--Record and play back a keyboard macro
--Search for text within a database
--Building queries visually or with SQL
--Editing table structure and data
Keywords: sql source control sql ide sql development sql version control query analyser visual sourcesafe visual source safe vss version control ultimate ide enables developers maintain manage ms sql databases made in usa supplementary files
|
|
|
insertXpress
insertXpress automatically generates INSERT scripts for Microsoft® SQL databases. If you need to transfer data between similar tables in different databases, then insertXpress is the answer for you!
An insertXpress INSERT script contains all of the data that you have selected from the source database. Just run it on the target database and it inserts the data automatically. You can append the transferred data, replace the existing data with it, or use it to update existing data (matched using the identity field).
A single insertXpress INSERT script, generated all at once, can contain data from several databases on several servers. insertXpress generates scripts from tables or views or a combination.
You can easily select the data to include using the versatile insertXpress Object Browser. This expands to show all objects in all databases on all servers, with individual check boxes at each level. When you select a table or view, insertXpress displays the columns in a separate pane, each with its own check box.
You can transfer all data, or specify the number of table rows to transfer.
You can use WHERE statements to select records for transfer. XpressApps' IntelliSense®-like Code Complete feature enables you to select tables and columns as you type.
InsertXpress transfers all data types, including IMAGE, BINARY and VARBINARY. You can omit IMAGE data if you want (sometimes it is too large).
You can include identity fields or have the target database automatically generate them.
Your INSERT scripts can transfer data to a named database or to the currently selected one.
insertXpress shows you the dependencies and scripting order of the data before it generates the script.
InsertXpress can produce a single script file, or split it into separate files by server, database or object. You can specify filenames or have insertXpress generate them.
In the insertXpress script viewer you can edit, save and run any INSERT script.
Keywords: insert scripts sql data transfer sql tables sql tools sql server tools ms sql tools ms sql server smart insert scripts moving data between tables different databases scripts java dynamic ip addresses
|
