sql server心得体会（SQL Server experience）.doc

sql server心得体会（SQL Server experience） My job is to maintain the database administrator, server database, often move a database in a server to another server, the experience of mobile data has some experience, hope and common exchange. 1. by DTS tool designer to import or export DTS designer powerful, support multi task, but also the visual interface, easy to operate, but people generally do not know much, if only part of the mobile table in the SQLServer database, using this method, the best, of course, can also move all of a table. In SQLServerEnterpriseManager, the expansion server left + right click, select the database, select the Alltasks/ImportData... (or Alltasks/ExportData...), enter the wizard mode, follow the prompts to step on the line, which can be very small, flexible copy data between different data source, very convenient. And you can save it as a DTS package. If you have the same replication task later, you can run the DTS package directly, saving time and effort. You can directly open the DTS designer, method is to expand the server name following the DataTransformationServices, LocalPackages, NewPackage in the right click, select the right side of the window, open the DTS designer. It is worth noting: if you want to copy the source database table has a foreign key, pay attention to the order of mobile, sometimes to batch move, otherwise the foreign key primary key index may be lost when the mobile options next to that said understand, or one-time copied to the target database, re establishment of foreign key primary key index. Database design experience of SQL Server database of six mobile data method, actually the establishment of database, the establishment of the primary key, foreign key, separate index files should be built and the table file, and the data files are separated, and were placed in a different drive, is in favor of optimizing database. Although this tool is not recommended in the SQLServer7 version, many database administrators st