怎样配置SqlDbx
- 格式:doc
- 大小:98.00 KB
- 文档页数:2
sqldbx使用手册
SQLDBX的使用手册主要包括以下内容:
1.简介:介绍SQLDBX的背景、功能特点、适用场景等。
2.安装与配置:详细介绍如何安装SQLDBX,以及如何配置连接参数、数
据库参数等。
3.连接与断开:介绍如何使用SQLDBX连接到数据库,以及如何断开连接。
4.数据查询:详细介绍如何使用SQLDBX进行数据查询,包括基本的
SELECT语句、条件查询、聚合函数等。
5.数据操作:介绍如何使用SQLDBX进行数据插入、更新、删除等操作。
6.数据库管理:介绍如何使用SQLDBX进行数据库管理,如创建表、视图、
存储过程等。
7.高级功能:介绍SQLDBX的高级功能,如事务处理、批处理等。
8.常见问题与解答:列举一些常见的问题,并提供解决方案。
9.附录:提供一些有用的附录,如SQLDBX的命令参考、连接参数说明等。
总之,SQLDBX的使用手册应该全面介绍SQLDBX的功能和用法,并提供详细的操作步骤和示例代码,以帮助用户快速上手和使用SQLDBX。
安装sql2008并配置ODBC一、安装SQL 2008把安装光盘插入光驱,自动读取进入安装中心,选择“安装”如果提示选择可用版本,请选择“Express”,并输入随光盘附带的序列号。
我这里是评估版,如有不同,请反馈。
勾选“我接受许可条款”,点击“下一步”是否有需要安装的组件,如果有,请按提示安装。
安装成功,点击“下一步”:选择“全选”,点击“下一步”:实例配置-创建实例名选择“默认实例”,如果提示有错误“该实例名称已在使用”,就选择“命名实例”,我在这里命名“MSSQLSERVER2008”,点击“下一步”:服务器配置-服务账户提示有错误,点击“对所有SQL Server服务使用相同的账户”,在弹出的对话框选择“NT AUTHORITY\NETWORK SERVICE”,点击“下一步”:配置sa连接选择“混合模式”,如图所示,提示有错误,选择“添加当前用户”,并且当前用户必须为管理员级别的账户还是提示缺少sa密码,先随便输个“123” ,待会儿再改又提示需要系统管理员,再添加当前用户,同上必须为管理员级别的账户下面都是“下一步”点击“下一步”,进入“安装进度”,等待若干时间安装,安装完成后请重启电脑。
进入“Microsoft SQL Server Management Studio”,在左边“对象资源管理器”中,依次展开“安全性”—“登录名”,右击“sa”选择“属性”,在弹出的对话框中,不勾选“强制实施密码策略”,并且修改密码为空。
二、sql2008配置ODBC1.在“ODBC”数据源管理器中选择“系统DSN”页面,点击“添加”:2.在“创建新数据源”对话框中,拖至页面底端选择SQL2008对应的“SQL Server Native Client 10.0”,点击“完成”:3.名称输入“mss3000v220conf”,服务器复制“服务管理器”的服务器名,输入“.\MSSQLSERVER2008”,点击“下一步”:复制这个4.点击“下一步”:5(更改默认的数据库为“mss3000v220conf”。
PLSQL常用配置1、PL/SQL Developer记住登陆密码在使用PL/SQL Developer时,为了工作方便希望PL/SQL Developer记住登录Oracle的用户名和密码;设置方法:PL/SQL Developer 7.1.2 ->tools->Preferences->Oracle->Logon History ,“Store history”是默认勾选的,勾上“Store with password” 即可,重新登录在输入一次密码则记住了。
2、执行单条SQL语句在使用PL/SQL Developer的SQL Window时,按F8键,PL/SQL Developer默认是执行该窗口的所有SQL语句,需要设置为鼠标所在的那条SQL语句,即执行当前SQL语句;设置方法:PL/SQL Developer 7.1.2 -->tools->Preferences-->Window types ,勾上“AutoSelect Statement” 即可。
3、格式化SQL语句在使用PL/SQL Developer的SQL Window时,有时候输入的SQL语句太长或太乱,希望能用比较通用的写法格式话一下,这样看起来会好看些,也好分析;使用方法:选中需要格式化的SQL语句,然后点击工具栏的PL/SQL beautifier按钮即可. 4、查看执行计划在使用PL/SQL Developer的SQL Window时,有时候输入的SQL语句执行的效率,分析下表结构,如何可以提高查询的效率,可以通过查看Oracle提供的执行计划;使用方法:选中需要分析的SQL语句,然后点击工具栏的Explain plan按钮(即执行计划),或者直接按F5即可。
5、调试存储过程在使用PL/SQL Developer操作Oracle时,有时候调用某些存储过程,或者调试存储过程;调用存储过程的方法:首先,在PL/SQL Developer左边的Browser中选择Procedures,查找需要调用的存储过程;然后,选中调试的存储过程,点击右键,选择Test,在弹出来的Test scrīpt窗口中,对于定义为in类型的参数,需要给该参数的Value输入值;最后点击上面的条数按钮:Start debugger 或者按F9;最后点击:RUN 或者Ctrl+R6.左下角显示window list点击菜单tools -> window list, 将弹出的小窗口拖到左下角合适位置,然后点击菜单window->save layout7.防止登录超时tools->Preferences-->Oracle->Connection 选择"check connection"8.不备份sql文件tools->Preferences->Files->backup,页面中backup files中选择disabled。
[精华] dbx 命令命令详解[转贴] 作者:li2002发表于:2007-11-02 11:12:20【发表评论】【查看原文】【C/C++讨论区】【关闭】dbx 命令用途提供了一个调试和运行程序的环境。
语法dbx [ -a ProcessID ] [ -c CommandFile ] [ -d NestingDepth ] [ -I Directory ] [ -E DebugEnvironment ] [ -p oldpath=newpath:...| pathfile ] [ -k ] [ -u ] [ -F ] [ -r ] [ -x ] [ ObjectFile [ CoreFile ] ]描述dbx 命令为 C、C++、Pascal 和 FORTRAN 语言程序提供了一个符号性的调试程序,允许您按照下面的内容执行操作:检验对象和核心文件。
为程序运行提供一个控制环境。
在选中的语句处设置断点或单步执行程序。
使用符号变量进行调试并将它们以正确的格式显示出来。
ObjectFile 参数是一个由编译器产生的目标(可执行)文件。
在编译您的程序时,使用 -g(生成符号表)标志产生 dbx 命令需要的信息。
注:cc 命令的 -g 标志应该在对象文件进行编译时使用。
如果没有使用 -g 标志或者如果符号引用被 strip 命令从 xcoff 文件中删除了,则 dbx 命令的符号性能将受到限制。
如果没有指定 -c 标志,dbx 命令将会在用户的 $HOME 目录中检查 .dbxinit 文件。
然后它在用户当前目录中检查 .dbxinit 文件。
如果在当前目录中存在一个 .dbxinit文件,该文件将覆盖用户的 $HOME 目录中的 .dbxinit 文件。
如果在发现了 .dbxinit 文件存在于用户的 $HOME 目录中或者当前目录中,该文件的子命令将在调试部分开始时运行。
使用编辑器创建一个 .dbxinit 文件。
SQL Server 2000与Exchange Server 2003 群集系统安装配置2004年1月20日目录1、需求场景 (3)2、配置方案 (4)2.1 方案一:标准配置 (4)2.2 方案二:精简配置 (4)3、安装配置步骤 (5)3.1 Windows Server 2003群集安装配置 (5)A、配置服务器与网络 (5)B、配置磁盘阵列柜 (7)C、配置服务器群集 (8)D、验证Windows Server 2003群集 (12)3.2 SQL Server 2000群集安装配置 (14)A、安装SQL Server 2000 (14)B、安装SQL Server 2000 SP3补丁包 (21)3.3 Exchange Server 2003群集安装配置 (25)A、Exchange 2003安装的Active Directory准备 (25)B、每个节点上安装Exchange Server 2003企业版 (30)C、创建配置Exchange 2003群集虚拟服务器 (41)4、SQL数据库与Exchange邮件群集功能测试验证 (49)4.1 验证SQL 数据库群集功能 (49)4.2 验证Exchange邮件群集功能 (52)1、需求场景许多企业采用了SQL Server提供业务系统后台数据服务,以及Exchange Server提供办公系统后台协作服务,随着企业运作对这些业务系统与办公系统的依赖,如何提高这些系统的高可靠性、高可用性已越来越引起企业的关注。
为满足企业系统高可用性容错业务需求,微软强力推荐用户采用Windows Server 2003企业版、SQL Server 2000企业版以及Exchange Server 2003企业版来构建其业务应用与协作办公平台。
由于Windows Server 2003、SQL Server 2000以及Exchange Server 2003企业版中内置Cluster群集功能,外加一共享磁盘柜或SAN,2台服务器就能实现群集配置,SQL Server 2000(节点服务器1)与Exchange Server 2003(节点服务器2)互为热备地对外提供服务,即充分利用了服务器硬件资源,又大大提高了整个业务应用与协作办公系统的高可用性,如下图所示:2、配置方案由于微软的Cluster群集配置必须要有域环境支持,依据域控制器是否有独立的物理服务器来承担,配置方案可分为两大类,暂且称为标准配置与精简配置,具体情况如下。
SqlDbx使⽤⽅法SqlDbx1. Overview of SqlDbxWelcome to SqlDbxSqlDbx is database administration and SQL development IDE focused on application developers who work in heterogeneous database environments.Features at a glance:High performance native support for major Database Servers including Microsoft, Sybase, Oracle and IBM DB2/UDB Browse / Explore ServersFast, intelligent, extensive and highly customizable IntellisenseAdvanced script Editor with Syntax highlighting, Auto Complete, Speed Typing, Drag/Drop, Undo/Redo, Find/Replace Unicode supportVisual Data DiffSQL ScriptingSQL Formatter / BeautifierGenerate SELECT, INSERT, UPDATE, DELETE, WHERE IN data modification statements directly from result grid SQL templates with replaceable formal parametersImport / Export to CSV, XML, ExcelSchema object browserSQL statement historyFavorite objectsSearch in Database and in Result gridDirectly edit table data in Result gridDisplay query plan and query statisticsSimple deployment and removal. No dll's or other dependencies. Just one executable (1.4 meg.)Supported DBMS SystemsOracle? 8i - 11gMicrosoft? SQL Server 6.5 - 2008IBM DB2? LUW 7.x - 9.xIBM DB2? z/OS 7.x - 9.xIBM DB2? iSeries 5x - 6.xSybase ASE? 10.x - 15.xSybase Anywhere? 9.x - 11.xSybase IQ? 12.5 - 12.7ODBC 3.0 compliant sources2. Using SqlDbxUsing SqlDbxSqlDbx window divided into three panes: Object Pane, Script Editor and Results Pane Editor ShortcutsGrid ShortcutsSQL Script EditorIntellisenseScript VariablesSQL TemplatesSpeed TypingVisual DiffExport / ImportGenerate ScriptsServer ExplorerOptionsCommand Line options2.1 Quick StartQuick StartWhen You start SqlDbx it automatically shows Server Login dialog. Select correct Server type, enter Server name, Database, User and Password and click button Login. If server found and client software installed correctly new SQL Editor window will open.Set Alias button can be used to create alternate user friendly name for the Server. Also it is useful when you connect to the same server using different credentials. Use Alt. Background an Text color check box allows to specify alternate text and background colors. This allows to visually differentiate between production and development Servers. Set Alias button allows to create multiple aliases for the same Server. You can create it by directly typing into Server combo box. Make sure that actual Server name enclosed between "(" and ")"Using SqlDbx2.2 Editor Keyboard ShortcutsEditor Keyboard ShortcutsLoad / SaveCtrl + N New ScriptCtrl + O Open fileCtrl + S Save active scriptCtrl + Shift + S Save active script with different name Ctrl + D Close active script tabCursor MovementLeft Move cursor one character leftRight Move cursor one character rightUp Move cursor one line upDown Move cursor one line downCtrl + Up Scroll screen upCtrl + Down Scroll screen downCtrl + Right Move cursor one word rightCtrl + Left Move cursor one word leftEnd Move to end of lineCtrl + End Move to end of last line in fileHome Move to beginning of lineCtrl + Home Move to beginning of fileEditCtrl + Y Delete current lineCtrl + Shift + Delete Delete allCtrl + Delete Delete to start of word to the rightCtrl + Backspace Delete to start of word to the leftInsert Switch between overwrite and insert mode Ctrl + C Copy to ClipboardCtrl + V Paste from Clipboard formatted as SQL Ctrl + Shift + V Paste from Clipboard Excel styleAlt + Shift + V Paste as column blockCtrl + Alt + V Paste as column block (fill)Ctrl + X Cut to ClipboardCtrl + Z, Alt + Back UndoShift + Tab Indent to the leftCtrl + Shift + C Comment selection outCtrl + Shift + R Un comment selectionCtrl + Shift + U Convert selection to upper case Ctrl + Shift + L Convert selection to lower case Ctrl + Shift + M Replace template parametersSelectionCtrl + A Select allAlt + Left Mouse Button Start column (block) selectionAlt + C Set block selection on. Use Shift + Arrow keys to extend selectionShift + Left MouseButtonExtend selection to click pointCtrl + B Select SQL block starting from current position Ctrl + Shift + B Select current block delimited by empty lines Shift +Left Extend selection to the LeftShift + Right Extend selection to the rightShift + Up Extend selection one line upShift + Down Extend selection one line downShift + Home Extend selection to the beginningShift + End Extend selection to the endShift + Page Down Extend selection one page downShift + Page Up Extend selection one page upCtrl + Shift + Home Extend selection from current position to the beginning of scriptCtrl + Shift + End Extend selection from current position to the end of script Ctrl + Shift + Left Extend selection to the beginning of current wordCtrl + Shift + Right Extend selection to the end of current word BookmarksCtrl + F2 Toggle bookmarkF2 Go to next bookmarkShift + F2 Go to previous bookmarkCtrl + Shift + F2 Clear all bookmarksMiscellaneousCtrl + E, F5 Execute SQL statementCtrl + F Show Find dialogF6 Quick FindF3 Find nextShift + F3 Find previousCtrl + G Go To LineCtrl + J Format selected SQLCtrl + M Highlight all words like the one under the cursorCtrl + H Show Replace dialogCtrl + Page Down Next Script windowCtrl + Page Up Previous Script windowCtrl + 1 Switch focus between Editor and Results Ctrl + 2 Switch focus between Editor and Object List Ctrl + 3 Set focus to Script EditorF7 List TablesF8 List Procedures and FunctionsF9 List System Functions2.3 Results Grid Keyboard ShortcutsResults Grid Keyboard ShortcutsCursor MovementUp Move one cell upDown Move one cell downRight Move one cell rightLeft Move one cell leftCtrl + Up Move up to the edge of data region*Ctrl + Down Move down to the edge of data region*Ctrl + Right Move right to the edge of data region*Ctrl + Left Move left to the edge of data region*End Enables "End" modeCtrl + End Move to the last grid cellHome Move to the first column in current rowCtrl + Home Move to the first grid cellSelectionLeft Mouse Button in top left corner Select allShift + Left Mouse Button on Column Header Select all columnShift + Left Mouse Button in grid area Extend selection from active cell to clicked cellLeft Mouse Button on Row Header Select all rowCtrl + Left Mouse Button Begin new selection without clearing current selection Shift + Left Extend selection one cell left Shift + Right Extend selection one cell rightShift + Home Extend selection to the first grid cellShift + End Extend selection to the last grid cellShift + Down Extend selection one cell downShift + Up Extend selection one cell upShift + Page Down Extend selection one page downShift + Page Up Extend selection one page upCtrl + Shift + Home Extend selection to the first grid cellCtrl + Shift + End Extend selection to the last grid cellCtrl + Shift + Left Extend selection left to the edge of data region*Ctrl + Shift + Right Extend selection right to the edge of data region* Ctrl + Shift + Up Extend selection up to the edge of data region*Ctrl + Shift + Down Extend selection down to the edge of data region* ClipboardCtrl + C Copy to ClipboardCtrl + Shift + C Copy to Clipboard with column headersCtrl + Alt + C Copy to Clipboard column headers only MiscellaneousCtrl + Shift + N New Result tabCtrl + Shift + D Close active Result tabLeft mouse button double click on columnToggle column sort ascending / descending headerCtrl + Left mouse button on column header Add column sortLeft mouse button on column header andRearrange columnsdrag* - data region: A range of cells that contains data and is bounded by empty cells2.4 SQL Script EditorScript EditorSQL Editor window provides broad range of editing capabilities. Look and feel can be configured in Options Dialog on Editor page. You can drag and drop text between different windows.To open a new script window press Ctrl + NSQL Editor Keyboard ShortcutsEditing ScriptsExecuting Scripts2.5 IntellisenseUsing IntellisenseIntellisense is configured in Options dialog on Editor page.Intellisense and temporary tables in MS Sql Server and Sybase ASE. For intellisense to work with temporary they have to be created and then "referenced". Referenced means that you have to type something in Editor to cause the information about them loaded. For example if you created temporary table named #tmp then just type #tmp. and after that #tmp table will start to show up in Intellisense list window.If you drop and recreate temporary table with different definition you have to refresh objects in a left pane in order to reset Intellisense information for temporary tables.Intellisense Options DescriptionEnable Intellisense Enables or completely disables following optionsInclude System Tables Display System Tables in Intellisense listInclude System Procedures Display System Procedures in Intellisense listInclude Schemas/Databases Display objects from other Schemas (Oracle, DB2) or other Databases (Sybase MS)Enable Auto Complete For: Enables or disable following optionsKeywords Displays and enables autocomplete for KeywordsUser Objects Displays and enables autocomplete for User ObjectsSystem Objects Displays and enables autocomplete for System objectsCapitalize Keywords Automatically capitalizes Keywords after you type space or separator character Capitalize Procedures/FunctionsAutomatically capitalizes Procedures/Functions2.6 Script VariablesScript VariablesScript Variables provide you with the flexibility of using a single script in multiple scenarios. For example if you need to run single script against multiple databases, instead of modifying the script for each database, you can use a scripting variable for the database name. Your define Script Variable by using following syntax:DEFINE var_name [=] [var_value] | [CHAR | VARCHAR | NUMBER | INT | INTEGER | NUMERIC | DECIMAl]where:= - optional assignment operatorvar_name - variable namevar_value- optional variable valueCHAR, VARCHAR, ... - optional variable typeTo reference script variable you use following syntax: for all databases except Oracle: $(var_name). In case of Oracle:&var_nameScript variables can appear anywhere in textExample of using Script Variables:Simple substitutionDEFINE var_date = 01/01/07DEFINE var_string 'String_Value'SELECT * FROM table_name where date_field = '$(var_date)' and string_field = $(var_string)The above select statement will be converted to:SELECT * FROM table_name where date_field = '01/01/07' and string_field = 'String_Value' Parameterized Query with substitution parametersDEFINE var_dateDEFINE var_stringParameterized Query with type safe substitution parametersDEFINE var_date DATEDEFINE var_string VARCHARSELECT * FROM table_name where date_field = '$(var_date)' and string_field = $(var_string)If you try to execute script above then window will popup asking to supply values for defined variable which do not have values assigned to them. This will be happen every time you execute above script because DEFINE statement will reset variable value to nothing. If Script variable contains type declaration then SqlDbx will try to convert specified values to corresponding type. If conversion fails then query will not be executed. For example if you specify string_value for var_string then it will be enclosed in single braces automatically or if type declared as DATE and your database is Oracle then it will be replaced byfunction TO_DATE(var_date, 'YYYY-MM-DD'). If no type specified or variable value provided then no conversion will apply. Script variables maintain values until they changed by DEFINE command.Script Variables naming rulesVariable names must not contain white space charactersVariable names must not have the same form as a variable expression, like $(var)Scripting variable names are not case-insensitive2.7 SQL TemplatesUsing SQL TemplatesTemplates are files containing SQL scripts that help you use predefined code templates. Template files should be copied to a directory defined in Options->General->Templates. Files should be copied into one of the subdirectories of path specified in Options. Template files are ordinary text files containing SQL code. The template files can use formal parameters to help you customize the code. Template parameter definitions use following format:whereparameter_name is the name of the parameter in the script.data_type is the data type of the parameter (optional).value is the value that is to replace every occurrence of the parameter in the script (optional). Example:CREATE PROCEDUREASBEGINEND ;Use the Replace Template Parameters dialog box to insert values into the script.Note You can use the Replace Template Parameters dialog box to specify values any time a parameter definition is used in code. For example, when you script execute function from Object View, the function written to the current Script window will contains parameter definitions for any arguments in the function. You can, therefore, use the Replace Template Parameters dialog box to specify argument values. Also if you have text selected in Editor and invoke Replace template Parameters dialog then only selection will be checked for any template parametersIt is possible to specify cursor position in template. Put symbol "^" anywhere in the template text. To use a templateOpen a Script window.If template manager window is not visible press Manage SQL Templates button on the toolbar.Navigate to desired template and select Insert Template menu item or double click left mouse button.When the template is displayed in the Script window, select Replace Template Parameters button on the toolbar.In the Replace Template Parameters dialog box, specify values for the parameters.To insert the specified values into the script in the Editor pane, click Replace.2.8 Speed TypingSpeed TypingSpeed typing configuration is accessible through menu Tools->Configure Speed Typing. Speed type definitions saved in a file whose name and location specified in Options general tab.Speed typing allows to define strings which automatically expanded when typed. Speed typing is integrated in Intellisense and Auto complete. Speed typing also supports substitution parameters. Examples:1. Simple replacement. If Shortcut column contains sla and column Substitution Value contains SELECT * FROM then when you type sla in Script Editor and press space it will be replaced by SELECT * FROM2. Use Speed typing to add Auto Complete strings. Simply enter desired string into Shortcut column and leave Substitutioncolumn blank3. Using formal parameters:If Shortcut column containssla (var_date, var_string)and Substitution column containsSELECT * FROM TABLE_NAME where date_col = '$(var_date)' and string_col = '$(var_string)'then when in Script Editor you type:sla (01/01/07, string_value)it will be expanded into:SELECT * FROM TABLE_NAME where date_col = '01/01/07' and string_col = 'string_value'To specify cursor position in Editor after speedword expansion put symbol '^' anywhere in text2.9 Visual DiffUsing Visual DiffVisual Diff allows to compare files or results from queries, procedures or any other valid SQL statement which can be executed on different servers. To get meaningful results when comparing data You have to consider couple of things. Results should have identical number of columns, do not include volatile columns like timestamp and columns should be sorted in a same order if possible.Visual Diff offer Quick Diff option. To use this option just do one of the following: select text in Editor or Result grid and drag / drop it to "Quick Diff" toolbar button on the main menu.After you do it twice Visual Diff screen will open automatically displaying difference. Also right click popup menu in Editor and Result grid has an option to execute "Quick Diff"2.10 Export / ImportExport / Import table dataExport to FileSelect Export To->File menu item from table popup menu. Saved file can be later opened as script file and executed directly. Import from FileYou can import previously exported data by selecting Import From->File menu item from table popup menu. If table name in the file different from selected table it will be automatically replaced. Also file can be opened as ordinary file in Script Editor. Export to ExcelSelect Export To->Excel menu item from table popup menu to copy all table data to ExcelImport from ExcelYou can import table data from Excel by first selecting range in Excel which contains table data with table column names in the first row. Order of columns is not important. Some column can be omitted too. To import data from Excel select table into which you want to import data. Right click and select Import From menu item. Select menu item with Excel session in which you previously selected data. Data from Excel will appear in a new Script Editor window as a series of INSERT statements. Now you can edit or execute script to insert data into the table.2.11 Generate ScriptsGenerate Scripts HelpThis dialog allows to generate DDL scripts for the current Schema / Database.2.12 Server ExplorerUsing Server ExplorerSqlDbx organizes information about servers in Server Explorer window. The Server Explorer provides fast and efficient way to access database objects. The Server Explorer contains multiple panels for each Server type with a tree control for each type. The tree organizes database objects as tree branches. By expanding or collapsing tree nodes you can easy browse and explore database objects. The Server Explorer includes two panes. Left pane displays database objects of currently selected Server and right pane shows summary for them.2.13 OptionsOptionsOptions Dialog is accessible from toolbar or Main Menu->Tools.General OptionsEditor OptionsColorsResults OptionsScripting OptionsImport / ExportServers2.14 Command Line OptionsCommand Line OptionsUsage: SqlDbx [-t] [-s] [-d] [-u] [-p] [-n] [-l] [[-q script file [-r]] [-w workspace file] Arguments-t server_type Can be one of the following: microsoft, sybase, oracle, ibm, mysql, odbc -s server_name Server to which to connect-ddatabase_nameDatabase / Schema name-u user User name. If -U and -P not supplied try to login using integrated security -p password User password-n Start new instance of SqlDbx. If -n not specified then pass arguments to the instance started wit none found then start new instance.-l Write debug log to SqlDbx.exe.log-q script file open specified script file-r if -q option specified then run loaded script-w workspace file load previously saved session state-c Clear registration informationCommand line flags are not case sensitive and space after them is optional *Command line options are supported only in SqlDbx Professional Edition2.15 Quick Tips TipsQuick tips01 Intellisense works better and in more cases when table names use aliases For example:select *from table_name1 T1, table_name1 T2 where T1.column_name = T2.column_name ...02 You can enable automatic save / restore of SqlDbx session state by checking Enable Session State check box on Gen03 Speed typing allows to create aliases for often used SQL blocks. For examples you can add string "sla" as alias for "s Typing04 Generate SELECT/UPDATE/INSERT/DELETE allows quickly to script SQL DML statements.05 If you want to quickly access object properties just click on object it in Editor and press Alt-F106 You can directly edit table data in Result Grid for tables with unique constraints07 Templates allow to organize snippets of code.08 Results Grid supports sorting and moving columns. Also it supports multiple selections. Hold Ctrl key while selecting m09 Quickly select SQL block by placing cursor on first character and then press Ctrl+B10 Quickly export data from table. Execute select * from , then select everything in Grid Results by clickin Generate->Insert from right click menu11 Filter data in Results Grid by selecting Filter menu item from right click popup menu12 Replace Template parameters works not only for templates but with any text enclosed in angle brackets "<...>"13 You can directly execute procedures and functions from Object View pane14 You can execute procedures from Editor by righ clicking on procedure name15 Results of any query operation will be put in a new Result Tab if you hold Shift key while selecting query action。
DM DBA手记之SQLServer移植到DM 一、概述随着国家对自主可控的日益重视,目前在党政机关、军队、大型央企等行业和区域中面临越来越多的国产化。
DM数据库和SQLServer结构存在差异,TSQL语法也存在差异。
DM数据库针对SQLServer做了部分兼容性。
但由于有根本性的差异,兼容度不高。
从SQLServer迁移到DM数据库,DM数据库提供了自动迁移工具,但在开发级别还需要人工干预进行同步。
SQLServer到DM的移植主要有以下几个方面的工作:1.分析待移植系统,确定移植对象。
2.通过数据迁移工具DTS完成常规数据库对象及数据的迁移。
3.通过人工完成TSQL的移植。
4.移植完成后对移植的结果进行校验,确保移植的完整性和正确性。
5.对应用系统进行移植、测试和优化。
二、移植过程2.1 待移植系统分析对待移植系统进行分析,确定需要移植的数据库对象,给出移植列表,给用户确认,作为移植的依据,给出SQLServer的统计脚本2.2.1 统计SQLServer数据库基础信息2.2.2 统计SQLServer数据中的对象以及表数据量a.根据指定用户统计用户下的各对象类型和数目b.统计指定用户下所有的对象,并记录到新的记录表中c.统计每个表的数据量到表数据记录表2.2 准备移植环境本节讨论的内容是关于对移植环境的准备工作,鉴于移植工作的最终目的可能不同,我们需要对目的做一下分类,分类之后,可以更好的明确我们的环境准备工作的需求,从而使使移植的工作更加的高效;(1)仅做移植兼容性测试。
这里指的是用户或者开发商对与移植可能性和技术工作量的一个评估和确认工作,也就是尝试性的移植,移植后可能并不会立刻进行产品级的应用功能、性能、稳定性测试,在这中情况下,我们一般搭建最基础的移植环境即可,用虚拟机和物理机服务器都可以进行,且对配置无特别要求,满足基本运行条件即可;(2)为替换SQLServer上线运行进行正式移植。
odbc数据源配置步骤ODBC数据源配置步骤ODBC(Open Database Connectivity)是一种开放式数据库连接技术,它允许不同的应用程序通过统一的接口来访问各种数据库。
在使用ODBC连接数据库之前,需要进行数据源配置,以确保应用程序能够正确连接到目标数据库。
下面将介绍ODBC数据源配置的详细步骤。
1. 打开ODBC数据源管理器在Windows操作系统中,可以通过控制面板中的“管理工具”或者在运行窗口中输入“odbcad32”命令来打开ODBC数据源管理器。
2. 添加数据源在ODBC数据源管理器中,切换到“用户DSN”或“系统DSN”选项卡(根据需要选择),然后点击“添加”按钮。
3. 选择驱动程序在弹出的“创建新的数据源”对话框中,选择适合目标数据库的驱动程序。
常见的驱动程序有SQL Server、Oracle、MySQL等。
4. 配置数据源属性在配置数据源属性的对话框中,需要填写以下信息:- 数据源名称:为数据源指定一个唯一的名称,用于在应用程序中引用。
- 描述:可选,用于描述数据源的信息。
- 服务器名称或IP地址:目标数据库所在的服务器名称或IP地址。
- 数据库名称:需要连接的数据库名称。
- 用户名和密码:登录数据库所需的用户名和密码。
5. 测试连接在填写完数据源属性后,可以点击“测试连接”按钮来测试连接是否成功。
如果连接成功,将显示一条成功的消息,否则将显示失败的消息并提供相应的错误信息。
6. 保存数据源配置在连接测试成功后,可以点击“确定”按钮来保存数据源配置。
此时,数据源将出现在ODBC数据源管理器的数据源列表中。
7. 在应用程序中使用数据源在应用程序中,可以使用ODBC API或者ODBC驱动程序提供的接口来使用已配置的数据源。
根据编程语言和开发环境的不同,使用方法会有所差异。
总结通过以上步骤,可以成功配置ODBC数据源,从而实现应用程序与目标数据库的连接。
在配置过程中,需要确保填写的信息准确无误,包括数据库的名称、服务器名称或IP地址、用户名和密码等。
霆智硬件SQL备份软件安装配置说明一.安装1 双击setup,出现安装界面,点击Next(下一步)2 点击I Agree(我同意)3 点击Next(下一步)4 点击Install(安装)5 点击Next(下一步)6 点击Finish(完成)二.配置1 安装完成后会弹出SQL配置界面2 依次输入SQL的IP地址,用户名密码3 点击Test SQL Connection 验证数据库连接此提示验证成功,点save(保存) 4 此处打钩,选择需要备份的数据库5 设置保存备份的文件夹地址点击add backup destination弹出此页面6 输入X8中的文件夹地址和X8登陆的用户名密码点击Test 测试连接,成功后点击Save(保存)这里设置保留多久后删除,前边是月,后边是天.7 设置备份时间计划Schedule this job 打钩然后点击设置(1)full Backup :调整完整备份时间,单位:小时Startin 计划备份开始时间(2)是否增量备份,如果需要请打勾,设置每次增量备份的时间,前边小时,后边分钟,根据需要调整(3)点击Save保存8.保存整体设置返回主界面后点击save(保存)选择保存设置文件的位置,也可以重命名设置文件9 启动备份计划点击Run Now 开始备份计划10.全部安装配置完成,全部关闭即可,软件自动触发备份计划.备份文件是压缩ZIP格式,也可以选择不压缩点击Advanced (高级设置)选择none 保存即可save三备份文件夹(可选择是否启用)主界面点击点击Add folder选择需要备份的文件夹,点确定即可.文件夹备份时间与SQL设置的增量备份时间相同,格式为压缩格式ZIP.注意事项:1.支持SQL2000 SQL2005 SQL20082.请确认SQL服务器的IP地址,验证方式,用户名,密码的正确性3.请确认X8的用户名,密码,存放文件夹的正确性4.请根据数据库大小调整完整备份和增量备份的时间,以免文件过大时间过短而没有备份完成5.文件夹备份后是ZIP压缩格式,不可选择不压缩.6.支持安装在局域网内的任何电脑上,但强烈建议安装在SQL服务器上,可以减少意外情况.。