Beginning SQL Server Modeling- P10

Tham khảo tài liệu beginning sql server modeling- p10, công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả
Nội dung trích xuất từ tài liệu:
Beginning SQL Server Modeling- P10CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITY Figure 7-22. M code for the PatternApplication module (left pane) In the Solution Explorer, right-click on References under MfgComponentModel, and select Add Reference. This will bring up the Add Reference dialog box. Click the Browse tab and navigate to the location of the PatternApplication.dll file (as shown in Figure 7-23). If you installed the sample to the following path My DocumentsOsloPatternApplication Then the path of the DLL file should be My DocumentsOsloPatternApplicationinDebugPatternApplication.dll.180 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITYFigure 7-23. Browsing to the PatternApplication.dll location If this resolves the error, then save all files (Ctrl-Shift-S), and you should be ready to build anddeploy to the database.Building the ProjectRight-click the project name and select the Build option (see Figure 7-24).Figure 7-24. Executing the build 181 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITY If the build is successful, you should see results similar to that shown in the Output window in Figure 7-25. Figure 7-25. Successful build results shown in the Output window Deploying to the Database Once the build is accomplished, you should be ready to deploy the model to SQL Server. First, however, you need to make sure you have a valid connection string to the database. Right-click again on the project name and select Properties, which should be at the bottom of the context menu (Figure 7-26). Figure 7-26. Selecting the project Properties window in the drop-down context menu Select the M Deployment at the bottom-left of the Properties pane (see Figure 7-27).182 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITYFigure 7-27. Preparing to configure the database connection string in the Properties pane Click the ellipsis button to the right of the connection string prompt. This will bring up theConnection Properties dialog (see Figure 7-28).Figure 7-28. Connection Properties dialog box 183 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITY Enter (local) for the server name, enter Repository for the database name, and click the OK button. You should see the connection string displayed in the M Deployment area of the Properties pane (shown in Figure 7-29). Look at this connection string to make sure everything makes sense. If you need to change something, it can be directly edited in the prompt. Figure 7-29. M Deployment area showing the connection string for the newly created MfgComponentModel database If you want to make sure everything is in order after setting up the connection string, click again on the ellipsis button to the right of the connection string prompt to bring up the Connection Properties dialog, and then click the Test Connection button in the lower-left corner. You should get a notification that the “Test connection succeeded” (see Figure 7-30). Click OK in the notification window, then the Cancel button in the Connection Properties dialog to return to the M Deployment area in the Properties pane.184 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITYFigure 7-30. Testing the database connection string At this point, you should be ready to deploy the model to the Repository database. Make sure you’vesaved all files by using the Ctrl-Shift-S Save All action. (No asterisk should appear on any tab.) Right-clickagain on the MfgComponentModel project in the Solution Explorer, then select Deploy (as shown inFigure 7-31). 185 Download from Wow! eBook CHAPTER 7  SQL SERVER MODELING SERVICES – SECURITY Figure 7-31. Selecting the Deploy option in the project context menu The deployment process writes a log to the Visual Studio Outpu ...