Mssql server (InfoPath) export and import and problems

Step 1: export the warehouse, which can be exported in the management center, or you can use powerassist, see the http://technet.microsoft.com/zh-cn/library/ee428293.aspx

Step 2: Copy the cmp file to the target server and use "Import-SPWeb-Identity http: // ServerName-Path d: baoxiao. cmp ", but the problem occurs here, prompting that the command is invalid, so you can go back and look at the knowledge of powerbench and find that you need to first run the following command:

$ Ver = $ host | select version if ($ ver. version. major-gt 1) {$ Host. runspace. threadOptions = "ReuseThread"} Add-PsSnapin Microsoft. sharePoint. powerShell Set-location $ home

An error "SPWeb object with ID or Url: XXXX not found" is reported ". I am very depressed because there is no problem in using this method to test the import on my own machine during export. After investigation, the problem occurs due to the database permission. This problem also causes an exception in programming new SPSite ("http: // ServerName. My practice is to add the user Currently logged on to the system to the database account. Note that this account must be modified as shown in the following figure (in the server role option ):

 

Then use powerbench to import the data.

Step 3: at this time, the form library data I migrated has already appeared on the new site, but an error "unexpected error" has occurred while opening the site. I am currently searching for this error, post it later. If you know why, please kindly advise me !!

...... Er, find the problem sheet because the form template corresponding to the form does not exist. I went to the old machine management center to download the form template and find the list of the required form templates, click the arrow on the right of the template title to be downloaded, and select "send to" and then select "download copy" to download.

Step 4: copy the template to the new server, open the management center of the new server, and click general application settings on the "quick start" page of the Management Center website ", on the "general application settings" page, click "upload form template" in the "InfoPath Forms Services" section to upload, after the upload is complete, activate it to the specified website set (you can go to the "Manage form template" to activate it ).