sqlXpressScript 2.0

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! //n//nAn 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). //n//nA 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. //n//nYou 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. //n//nYou can transfer all data, or specify the number of table rows to transfer. //n//nYou 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. //n//nInsertXpress transfers all data types, including IMAGE, BINARY and VARBINARY. You can omit IMAGE data if you want (sometimes it is too large). //n//nYou can include identity fields or have the target database automatically generate them. //n//nYour INSERT scripts can transfer data to a named database or to the currently selected one. //n//ninsertXpress shows you the dependencies and scripting order of the data before it generates the script. //n//nInsertXpress 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. //n//nIn the insertXpress script viewer you can edit, save and run any INSERT script.