Có 200+ tài liệu thuộc chủ đề "database SQL"
tailieu.vn Xem trực tuyến Tải xuống
need to describe the structure of the file to BCP. When you use character or Unicode files, however, you must describe the structure of the data in the file to BCP. Head of the Class…. If you receive a data file that has the data stored as character data, the way those characters are encoded can be an issue. In...
tailieu.vn Xem trực tuyến Tải xuống
When the preceding command is run, it produces a data file named Presidents.tsv that looks like this:. You could turn around and import the data right back into the same table with the command (again, the command should be entered on a single line):. bcp AdventureWorks2008.dbo.Presidents in Presidents.tsv -T -f Presidents.fmt. Of course, the problem would be that the data...
tailieu.vn Xem trực tuyến Tải xuống
After running the statement, however, you get a simple report back from SQL Server:. So as you can see the BULK INSERT statement is very similar in functionality to the BCP command line utility. In the next two sections, well discuss a few pointers on maximizing the performance of your bulk loads. We’ll start by looking at how the transaction...
tailieu.vn Xem trực tuyến Tải xuống
In the last few sections we have discussed a broad range of bulk load operations.. The BCP and BULK INSERT statements both assume that you will be working with flat files, and SQL Server. Distributed queries are one way to do that, and we’ll talk about those next.. Distributed Queries. Distributed queries make it possible for you to have SQL...
tailieu.vn Xem trực tuyến Tải xuống
Using the OPENROWSET Function. The OPENROWSET function can be used to access data from data sources external to SQL Server. The OPENROWSET function can also be used as yet another way to bulk load data into SQL Server.. That means that the result of the call to the function is actually a table. Start by seeing how to use SQL...
tailieu.vn Xem trực tuyến Tải xuống
However, using the BULK option of OPENROWSET does allow you to do something that you can’t do with BCP and BULK INSERT—read the entire external data file as a single value. You can do this by using the SINGLE_BLOG, SINGLE_. The following example shows a query of the SomeXML table and the results:. is one of the more obscure bulk-loading...
tailieu.vn Xem trực tuyến Tải xuống
This procedure allows you to specify the name of the linked server, which OLE DB provider should be used, and some basic information about the linked server. This procedure has to be run before you can configure the linked server further.. Once the linked server exists, you can set some options on it using the sp_serveroption stored procedure. By setting...
tailieu.vn Xem trực tuyến Tải xuống
Let’s start by looking at the Copy Database Wizard.. Using the Copy Database Wizard. The Copy Database Wizard gives SQL administrators an easy way to copy an entire database between two SQL Server instances. The obvious goal of the Copy. Database Wizard is to make a copy of an entire database. Normally, this is going to be between two instances...
tailieu.vn Xem trực tuyến Tải xuống
writing a query to extract specific data from the source. Of course, to write a query the source must support queries when the source has multiple tables or support queries. If you are pulling from a flat file (like a .csv file), you can get only the data that is in the file. If, however, you were importing data from...
tailieu.vn Xem trực tuyến Tải xuống
In the Project Types list select the left Business Intelligence Projects and then in the Templates list on the right, select Integration Services Project.. Finally, you can complete the New Project window by giving your project a name, selecting the location of the parent folder that the project will be created under, and creating a solution for the project to...
tailieu.vn Xem trực tuyến Tải xuống
Once they have the packages developed and functioning, they can create a deployment utility that administrators can use to deploy those packages to the production server. First, let’s discuss Package Configurations, a feature that allows administrators to reconfigure packages in the production environment.. In this exercise, you will use BIDS to open the package you created in Exercise 8.7 using...
tailieu.vn Xem trực tuyến Tải xuống
Once a package is deployed you can control who has the ability to run it and change it. For packages saved to the file system, you can simply use NTFS permis- sions to control security. Regardless of how access to the packages is handled, however, the sensitive information needed in a package (like credentials for data- bases) is never stored...
tailieu.vn Xem trực tuyến Tải xuống
In this exercise, you will use the DTExecUI utility to execute the package that you created in Exercise 8.7 using the Import and Export Wizard.. This exercise assumes that you have administrative privileges on the SQL Server instance that you are working with, that you have the. AdventureWorks2008 sample database installed on your SQL Server instance, that BIDS is installed,...
tailieu.vn Xem trực tuyến Tải xuống
You can import from a file with a header row, however, by using the –F switch to skip the first row.. Q: I need to create a format file for my import to work. Should I use a non-XML format file or an XML format file?. A: If you need to maintain compatibility with an older version of BCP, you...
tailieu.vn Xem trực tuyến Tải xuống
You want to ensure that you get the entire database as well as any logins and SQL Server Agent Jobs related to the database. You need to import data from an Access database into a database in SQL Server. You need to deploy an SSIS package to a production server. “SQL Server Integrations Services Packages” step in a job.. Your...
tailieu.vn Xem trực tuyến Tải xuống
You can implement replication for the following scenarios:. You can point your applications to these servers to distribute load. For example, you can use read-only databases for reporting and analysis and therefore, the main database will handle only the transactions.. Replication can be used for such. However, unlike in database mirroring, in replication you need to find a mechanism to...
tailieu.vn Xem trực tuyến Tải xuống
These scripts are written to a folder in the file system called a snapshot folder. Apart from writing scripts to snapshot folder, the snapshot agent will write commands to the distribution databases.. Distribution Agent This agent will read from a snapshot folder and distribution database to propagate to the subscriber end.. Transactional replication is the most used replication type out...
tailieu.vn Xem trực tuyến Tải xuống
Therefore, in this chapter we will look at how to configure Merge Replication. Later we will discuss how to configure Peer-to-Peer Replication.. Before configuring any replications on your server, you need to configure your distribution. If no distribution is available when configuring publication, the publication wizard will ask for relevant information to configure the distribution.. SQL Server 2008.. Supply the...
tailieu.vn Xem trực tuyến Tải xuống
Figure 9.6 Adding Filters. it is better if you can schedule the snapshot during off-peak hours of the database.. After the configuration of Publisher, the next task is to configure Subscriber to access data in the publications of Publisher. Navigate to the Replication node in the SQL Server Management Studio. Figure 9.7 Choosing Replication for Subscriber. At the next screen...
tailieu.vn Xem trực tuyến Tải xuống
Next, you will see the Configure Topology, which is the new addition in SQL Server 2008. Right-click the window to add the databases you need to add to the Peer-to-Peer Replication and peer originator id. The beauty of this feature is that, in case of an expansion, you can add few more nodes to the topology without much trouble.. Conflict...