| |
|
|
| Smart INSERT scripts for moving data between tables in different databases! Transfers all data types, including IMAGE, BINARY and VARBINARY, from tables or views. Appends, replaces or updates data. Uses IntelliSense® in WHERE statements. |
| Other software from this author: | - Speed SQL IDE Pro 1.6.8 — Speed SQL IDE is the leading tool for database object development on the SQL Server platform. Its unique graphical object editors which incorporate many of the features that developers look for in an IDE.
- requestXpress 0.5 Beta — requestXpress helps manage software development projects by tracking software bugs/problems/requests as they are reported. requestXpress works with Microsoft award winning MS SQL database that supports simultaneous access by multiple users.
- XpressProps 1..0.0.1 — XpressProps is a SQL Tool designed to enable documentors and developers to add and maintain extended properties for all objects in SQL Server 2000.
| | Show all software from this author |
Description:
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. | System Requirements:
ADO 1.27 | | sqlXpressScript 2.0 Download from files.xpressapps.com |
| Similar software: | - Apex SQL Clean 3.1 — Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures. If database object bloat is the problem, Apex SQL Apex SQL Clean is the solution.
- Apex SQL Script 3.93 — Apex SQL Script© creates insert scripts from any Microsoft® SQL Server© 7 or 2000 database that can be archived, emailed, checked into source control, run against another database etc.
- Database Assistant 4.1 — Manipulate data from a variety of database formats including Oracle, SQL Server, Informix, MS Access, and Sybase et al with the Markosoft Database Assistant.
| | Find all software similar on sqlXpressScript 2.0 |
|
