Sharepoint 2007 如何找出占用儲存空間大的清單或文件庫?

要如何找出 Sharepoint 2007 占用磁碟空間的兇手呢?

 

簡要的說：

1.管理中心->應用程式管理->網站集合配額與鎖定：設定配額

2.網站設定->網站集合管理->儲存空間配置來查詢

 

 

 

 

 

 

 

http://guru-web.blogspot.tw/2009/04/storage-space-allocation-reports.html

KB-Redmine 網站反應速度很慢

Redmine 裝在 WEBrick 1.9.3 上面，某些電腦有可能出現速度很慢的問題，這是因為 WEBrick 有進行 DNS 反查的動作，若有電腦開啟防火牆，不允許反查的話，就有可能會發現 Retry。

 

可以解決茶包的方法， Windows 是在 ruby 安裝目錄裡面，例如：C:\Ruby\v1.9.3\lib\ruby\1.9.1\webrick

=============

Having the same issue here (even a year later). Under linux you have to do the following:

Look for the file /usr/lib/ruby/1.9.1/webrick/config.rb and edit it.

Replace the line

:DoNotReverseLookup => nil,

with

:DoNotReverseLookup => true,

Restart webrick and it'll work like a charm :)

 

http://stackoverflow.com/questions/1156759/webrick-is-very-slow-to-respond-how-to-speed-it-up/3465134#3465134

Redmine-如何批次修改問題 How to Batch Edit Issue

很簡單…在問題的表格上按下右鍵就有了

Redmine 2.3.3 Install on Windows

主要參考文件

http://www.redmine.org/projects/redmine/wiki/RedmineInstall

 

安裝步驟如下：

1.Ruby 1.9.3

2.Ruby DevKit (Ruby 1.8.6 to 1.9.3: tdm-32-4.5.2)<==不同版本配不同的DevKit

3.Rails 3.2.13

4.Redmine 2.3.3

 

遇到的問題：

 

Q1.無法連外網，要使用 HTTP_PROXY ，怎麼做

Q2.無法使用 HTTPS 連至 https://rubygems.org/ ，怎麼辦?

Q3.好用的 Plugin 有那些?

 

 

1.Ruby 1.9.3

The required Ruby versions for a given Redmine version is:

Redmine version	Supported Ruby versions	Rails version used
current trunk	ruby 1.8.72, 1.9.2, 1.9.3, 2.0.01, jruby-1.6.7, jruby-1.7.2	Rails 3.2.13
2.3.0	ruby 1.8.72, 1.9.2, 1.9.3, 2.0.01, jruby-1.6.7, jruby-1.7.2	Rails 3.2.13
2.2.4	ruby 1.8.72, 1.9.2, 1.9.3, jruby-1.6.7	Rails 3.2.13

 

Ruby 1.9.3-p448

 

2.Ruby DevKit (Ruby 1.8.6 to 1.9.3: tdm-32-4.5.2)<==不同版本配不同的DevKit

For use with Ruby 1.8.7 and 1.9.3:http://rubyinstaller.org/downloads/

• DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe

 

3.Rails 3.2.13

 

gem install rdoc

gem install rails -v=3.2.13

gem install bundler

 

D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'nokogiri (< 1.6.0) x86-mingw32' in the gems available o
n this machine.[0m
[33mRun `bundle install` to install missing gems.[0m

 

 

gem install nokogiri -v=1.5.10

 

D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'rmagick (>= 2.0.0) x86-mingw32' in the gems available o
n this machine.[0m
[33mRun `bundle install` to install missing gems.[0m

 

 

set CPATH=”C:\Program Files (x86)\ImageMagick-6.8.7-Q16\include”
set LIBRARY_PATH=C:\Program Files (x86)\ImageMagick-6.8.7-Q16\lib

 

D:\redmine-2.3.3>bundle install --without development test rmagick
Fetching source index from https://rubygems.org/
Could not verify the SSL certificate for https://rubygems.org/.
There is a chance you are experiencing a man-in-the-middle attack, but most
likely your system doesn't have the CA certificates needed for verification

information about OpenSSL certificates, see bit.ly/ruby-ssl. To connect wit
using SSL, edit your Gemfile sources and change 'https' to 'http'.

 

Notepad.exe Edit Gemfile

source 'http://rubygems.org'

 

 

D:\redmine-2.3.3>gem install rmagick
ERROR:  Error installing rmagick:
        The 'rmagick' native gem requires installed build tools.

Please update your PATH to include build tools or download the DevKit
from 'http://rubyinstaller.org/downloads' and follow the instructions
at 'http://github.com/oneclick/rubyinstaller/wiki/Development-Kit'

 

download DevKit & run devkitvars.bat to add PATH

D:\redmine-2.3.3>d:\share\RubyDevKit\devkitvars.bat

For use with Ruby 1.8.7 and 1.9.3:http://rubyinstaller.org/downloads/

• DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe

 

gem install rmagick --platform=ruby -- --with-opt-lib=c:/ImageMagick/lib --with-opt-include=c:/ImageMagick/include

 

D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'jquery-rails (~> 2.0.2) x86-mingw32' in t
ble on this machine.[0m
[33mRun `bundle install` to install missing gems.[0m

 

 

 

Q1.無法連外網，要使用 HTTP_PROXY ，怎麼做?

SET HTTP_PROXY=http://<ip>:<port>

 

 

Q2.無法使用 HTTPS 連至 https://rubygems.org/ ，怎麼辦?

Fetching source index from https://rubygems.org/
Could not verify the SSL certificate for https://rubygems.org/.
There is a chance you are experiencing a man-in-the-middle attack, but most
likely your system doesn't have the CA certificates needed for verification

information about OpenSSL certificates, see bit.ly/ruby-ssl. To connect wit
using SSL, edit your Gemfile sources and change 'https' to 'http'.

 

Notepad.exe Edit Gemfile

source 'http://rubygems.org'

 

Q3.好用的 Plugin 有那些?

 

剪貼簿貼上

https://github.com/peclik/clipboard_image_paste

RedmineCRM:Check List

http://redminecrm.com/projects/checklist/pages/1

 

http://redminecrm.com/pages/plugins

 

Q4.如何 Run as Windows Service

 

HowTo run Redmine as a Windows service (win32-service + taskill approach)

 

sc create redmine binPath= "C:\Ruby193\bin\rubyw -C D:\redmine\ service.rb"

 

 

參考連結

 

在 Windows 上安裝 Redmine 2.3.0 的筆記

http://crboy.logdown.com/posts/141615-install-redmine-on-windows

在 Windows 架設 Redmine 專案管理平台的安裝設定筆記

http://www.imagemagick.org/script/binary-releases.php#windows

Outlook 2013 的尺規不見了?

剛剛換了 Oulook 2013 ，寫信寫到一半，插入表格後，想利用尺規來調整表格欄寬，結果一直找不到藏到那邊去了，後來還是 Google 後才找到解決方式。

 

解決方式如下圖

 

 

原文網址

http://www.msoutlook.info/question/739

[P2V] 實體主機虛擬化經驗筆記

最近需要將一台NB搬進虛擬化的世界，之前經驗上使用了 Acronis True Image 來進行實體轉虛擬的動作，

本次使用了微軟的 Disk2VHD 的工具，這個工具的介紹，蘇老寫得很仔細，我就先跳過。

 

微軟免費的P2V工具-Disk2vhd

使用微軟Disk2vhd P2V工具的小提醒

 

結果使用了自動修復程序仍無法成功開機，後來使用了安全模式來移除不必要的驅動程式，方法如下：

 

開始 > 執行 > cmd, 然後在command prompt 內鍵入：

set devmgr_show_nonpresent_devices=1

之後再鍵入：

devmgmt.msc

這時會開啟裝置管理員，在工具列的檢視內選取「顯示隱藏的裝置」，然後在這裡會看到一些灰色的裝置，這些就是以往安裝了的驅動程式，確認沒用後就可以將它移除掉了。

 

參考資料來源：http://www.e-zone.com.hk/tips.php?tipsid=2298

TFS is slow

 

http://stackoverflow.com/questions/7428052/suggestions-for-troubleshooting-slow-tfs-server

 

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe.config

 

<system.net>
    <defaultProxy enabled="false"/>
    <settings>
        <ipv6 enabled="true"/>
    </settings>
</system.net>

HowTo: Windows 使用 ImageMagick 與 Ghostscript 來進行 PDF 轉 TIFF

安裝 ImageMagick  for windows

http://www.imagemagick.org/script/binary-releases.php#windows

安裝 Ghostscript for windows

http://www.ghostscript.com/download/gsdnld.html

 

 

寫一支 pdf2tiff.bat 檔，轉出格式為「高解析度的傳真用 TIFF」也就是俗稱的 TIFF G3/G4 Format

C:\ImageMagick\convert -density 204x196 -monochrome -compress Fax  %1 %2

 

接下來就可以呼叫產生

tiff2pdf.bat d:\temp\a.pdf d:\0temp\a.tif

 

看一下檔案內容，沒錯，就是 FAX TIFF 的格式

 

 

之前本來有打算採用 Reporting Service 來產生 FAX TIFF ，但是不通，因為不是 FAX 使用的 TIFF 格式(壓縮方式不同)

 

 

 

FAQ

如果沒有安裝 Ghostscript 的話，會出現

While reading gs_lev2.ps:
%%[ Error: invalidaccess; OffendingCommand: put ]%%

 

參考資料

Ghostscript PDF -> TIFF conversion is awful for me, people rave about it, I alone look sullen

Converting PDF to TIFF or text in C#

Best way to convert pdf files to tiff files [closed]

http://en.wikipedia.org/wiki/Tagged_Image_File_Format

親愛的Excel請不要再自作多情將恒生指數HSI啟動自動拼音校正改為HIS(他)

今天遇到要輸入 HSI 恒生指數的代碼，結果 Excel 就一直幫我換成 HIS ，後來發現，檔案->選項->校訂->自動校正->自動取代字串，有一個 hsi –>  his，但是明明我寫的是大寫，應該要忽略才對，只好將「自動取代字串」取消後就正常… Orz…

SQL Agent Log Error The process could not be created for step 1 of job reason 1314

今天發現一個錯誤訊息

The process could not be created for step 1 of job reason 1314

 

尋線追查後發現，若 SQL Agent 帳號有變更，需加入群組 SQLServer2005SQLAgentUser$<machine_name>，再重啟 SQL Agent 服務後排除問題

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f5201165-d675-46a7-abc7-24c92adb362b/

1314 = "A required privilege is not held by the client."
It is the SQL Agent account with the trouble perhaps, and not just the proxy account.
Make sure you reset the SQL Server service account by using the Configuration Manager, so that the service account you choose gets added into SQLServer2005SQLAgentUser$<machine_name>. If the current service account for SQL Agent is not in that group, add it to that group manually, or swap the service account to local system, save, then swap it back again to the desired account and type the password (using configuration manager)
You may have missed a couple of the user rights (administrators group may not include these privileges)
http://msdn.microsoft.com/en-us/library/ms143504(SQL.90).aspx
- Log on as a service (SeServiceLogonRight)
- Act as part of the operating system (SeTcbPrivilege) (only on Windows 2000)
- Log on as a batch job (SeBatchLogonRight)
- Replace a process-level token (SeAssignPrimaryTokenPrivilege)
- Bypass traverse checking (SeChangeNotifyPrivilege)
- Adjust memory quotas for a process (SeIncreaseQuotaPrivilege)

KB-The EXECUTE permission was denied on the object usp_Michael, database dbMichael, schema 'dbo'

若帳號只屬於 db_reader，不是屬於 db_owner 角色時，語法中含有 store procedure or function 時，會出現此類錯誤訊息

The EXECUTE permission was denied on the object ????, database ????, schema 'dbo'

 

解決方式：

1.建立角色

CREATE ROLE [myRole] AUTHORIZATION [dbo]

2.設定執行預存程序或函式權限給與角色

GRANT EXEC ON dbo.usp_Michael TO myRole

 

3.將登入帳號加入角色

EXEC sp_addrolemember N'myRole', N'login_user'

TF10151 Can not lock item xxx.dll for check out. this item has been xxx check out on xxx workspace (VS2010)

 

---------------------------
Microsoft Visual Studio
---------------------------
TF10151: 無法鎖定項目 $/xxxx.Wcf.dll 以簽出。項目 $/xxxx.dll 已在工作區 xxxxxx 中由 xxxx 簽出。
---------------------------
OK  
---------------------------

---------------------------
Microsoft Visual Studio
---------------------------
The command you are attempting cannot be completed because the file xxxx.dll' that must be modified cannot be changed. If the file is under source control, you may want to check it out; if the file is read-only on disk, you may want to change its attributes.
---------------------------
OK  
---------------------------

 

發生的原因在於 VS2010 在 WebSite Project 的 Reference DLL 會自動 check out，加上 TFS 針對 DLL 這個類型是不允許合併(non-mergable)，所以就會自動 Lock 鎖定。

 

目前我解決的方式是將 Team Project Collection 中，針對 dll 這種型別 check out 時，不需進行鎖定

 

The connection name 'OraAspNetConString' was not found in the applications configuration or the connection string is empty

Event code: 3008
Event message: A configuration error has occurred.
Event time: 2013/3/18 下午 04:36:49
Event time (UTC): 2013/3/18 上午 08:36:49
Event ID: 14538e1dd6d04500b57f0eaee698b821
Event sequence: 103
Event occurrence: 1
Event detail code: 0
Application information:
    Application domain: /LM/W3SVC/1/ROOT/TEST/xxxxx 
    Trust level: Full
    Application Virtual Path: /TEST/xxxxx
    Application Path: D:\WEB\TEST\xxxxx\
    Machine name: MichAdelPC
Process information:
    Process ID: 38460
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
    Exception type: ConfigurationErrorsException
    Exception message: 在應用程式組態中找不到連線名稱 'OraAspNetConString', 或者連線字串空白. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 284)
   at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
   at System.Web.Configuration.ProvidersHelper.InstantiateProviders(ProviderSettingsCollection configProviders, ProviderCollection providers, Type providerType)
   at System.Web.Configuration.SiteMapSection.get_ProvidersInternal()
   at System.Web.SiteMap.Initialize()
   at System.Web.SiteMap.get_Providers()
   at Admin.Menu.BindMenu() in d:\WEB\TEST\xxxxx\admin\menu.ascx.cs:line 85
   at Admin.Menu.OnLoad(EventArgs e) in d:\WEB\TEST\xxxxx\admin\menu.ascx.cs:line 60
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.default_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\xxxxxx\1cb83f19\15321ffe\App_Web_4cg0xawa.8.cs:line 0
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

在應用程式組態中找不到連線名稱 'OraAspNetConString', 或者連線字串空白.
   at Oracle.Web.Util.ReadConnectionString(NameValueCollection config)
   at Oracle.Web.SiteMap.OracleSiteMapProvider.Initialize(String name, NameValueCollection config)
   at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)

 

原因： Oracle Client 於 11gR5 之後，提供 ASP.NET Membership for Oracle，但是在安裝 Oracle 時，會要再進階設定才會正常

修正方式：

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

<system.web>

<membership><providers>：移除 

<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />

<profile><providers>：移除

<add name="OracleProfileProvider" type="Oracle.Web.Profile.OracleProfileProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />

<roleManager><providers>：移除

<add name="OracleRoleProvider" type="Oracle.Web.Security.OracleRoleProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />

<siteMap><providers>：移除

<add name="OracleSiteMapProvider" type="Oracle.Web.SiteMap.OracleSiteMapProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" securityTrimmingEnabled="true" />

<webParts><personalization><providers>：移除

<add name="OraclePersonalizationProvider" type="Oracle.Web.Personalization.OraclePersonalizationProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />

<healthMonitoring><providers>：移除

<add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />

PPPoE/ADSL/光世代固定IP如何自動撥接?(Windows平台)

建立一個設定檔取名叫做 rasinfo.bin

(重要：請將設定檔放在一個安全的地方，例如 c:\windows\)

格式：

<PPPoE名稱>【tab】<撥接使用者名稱>【tab】<撥接密碼>

說明：

<PPPoE名稱>：要跟下圖撥接名稱相符

 

建立一個批次檔，DslAutoDial.bat

==========================================================

@echo off
setlocal enabledelayedexpansion
::rasinfo.txt
:: one line
:: <connection name><tab><username><tab><password>
:: Nothing else!!
for /F "tokens=1-3 delims=    " %%a in (c:\windows\rasinfo.bin) do (
    set ras_connect=%%a
    set ras_user=%%b
    set ras_pass=%%c
)
for /f "tokens=1* delims=:" %%a in ('ipconfig') do set exclude=%%b
set exclude=%exclude:~1,-1%

:loop
ping google.com -n 1|find /v "%exclude%"|>nul find /i "reply"
if not errorlevel 1 (
    echo Connected ^^ sleep 10 sec...
     >nul ping 0.0.0.0 -n 10
) else (
    ping google.com -n 1|find /v /i "%exclude%"|>nul find /i "reply"
    if errorlevel 1 (
        echo "PACKETS NOT BEING RECIEVED Orz..."
        rasdial %ras_connect% /disconnect
        rasdial %ras_connect% %ras_user% %ras_pass%
    )
)
goto loop

===================================================

說明：此批次檔會去 ping 0.0.0.0 若是沒有收到封包時就會撥接 PPPoE

 

 

設定排程：

啟動時間有兩個，一個是開機時跑，另一個是每小時跑一次

 

 

這樣子做就可以省一些錢去買自動撥接的軟體囉

怪現象 TFS2012 , TF14045 the identity guid is not a recognized identity

遇到 TF14045 識別(Identity)錯誤，原本以為是 TFS2012 Update1的錯誤，但是與微軟連繫後，取得 hotfix 安裝後，仍是無法解決。

 

後來直接使用 SQL Profiler 抓取 TFS 的動作後，發現有以下指令

 

↓SQL Profilier請抓取 SP:Completed 及 RPC:Completed 這兩個事件

 

 

[copy code]

declare @p3 dbo.typ_GuidInt32Table
insert into @p3 values('<IDENTITY-GUID>',0)

exec prc_ReadIdentities @partitionId=1,@descriptors=default,@ids=@p3

declare @p2 dbo.typ_GuidTable
insert into @p2 values('<IDENTITY-GUID>')

exec prc_ReadGroupMembership @partitionId=1,@identityIds=@p2,@childrenQuery=0,@parentsQuery=0,@includeRestricted=0,@minInactivatedTime=NULL,@scopeId='<SCOPE-GUID>',@returnVisibleIdentities=1;

   1:  declare @p3 dbo.typ_GuidInt32Table

   2:  insert into @p3 values('<IDENTITY-GUID>',0)

   3:   

   4:  exec prc_ReadIdentities @partitionId=1,@descriptors=default,@ids=@p3

   5:   

   6:  declare @p2 dbo.typ_GuidTable

   7:  insert into @p2 values('<IDENTITY-GUID>')

   8:   

   9:  exec prc_ReadGroupMembership @partitionId=1,@identityIds=@p2,@childrenQuery=0,@parentsQuery=0,@includeRestricted=0,@minInactivatedTime=NULL,@scopeId='<SCOPE-GUID>',@returnVisibleIdentities=1;

LINE4，會出現結果，但是 LINE9就回傳空的結果集，這就有可能造成爆炸的原因。

 

解決的方式為：

在專案中加入此使用者，再查詢後就會 Active=1 的結果，若不需要此使用者繼續參與專案的話，可以再移除，此時會出現 Active=0

 

 

 

參考資訊：

升级TFS2012查看SOURCE-history部分提示TF14045: The identity xxx is not a recognized identity

升级TFS2012查看SOURCE-history部分提示TF14045: The identity xxx is not a recognized identity

怪現象 VS2012 Publish not working

遇到了一個怪現象， VS2012 的 Publish 不動作，開啟茶包訊息輸出也找不到原因

 

3>        Done building target "GatherAllFilesToPublish" in project "xxxx.csproj".
3>Done building project "xxxx.csproj".
3>Publishing folder /...
3>
========== Build: 0 succeeded or up-to-date, 0 failed, 2 skipped ==========
========== Publish: 1 succeeded, 0 failed, 0 skipped ==========

 

Publish Profiles 有放在專案裡面，設定檔砍掉再試試看一次，結果…成…功…了!!

 

找了一下網路的解決方式，似乎對我沒有用，我已經將我的解決方法丟至 StackOverFlow。

http://stackoverflow.com/questions/12201146/visual-studio-2012-web-publish-doesnt-copy-files

如何使用 Andriod SDK Emulator 建立 Note II 模擬器

 

 

1.下載 Android SDK

http://developer.android.com/sdk/index.html

http://dl.google.com/android/adt/adt-bundle-windows-x86_64.zip

 

2.用 Android Virtual Device Manager 設定 Device

…adt-bundle-windows-x86_64\sdk\tools>android.bat avd

 

 

啟動模擬器

adt-bundle-windows-x86_64\adt-bundle-windows-x86_64\sdk\tools>emulator.exe -avd note2

 

 

參考資訊

Using the Android Emulator

http://developer.android.com/tools/devices/emulator.html

筆記：使用 VSSConvert.exe 將 SourceSafe Database 轉入 TFS 2012

Franma已經寫得很清楚，如何利用VSSConvert 工具將 VSS 2005 移轉至 TFS 2010

黑大也有一篇文章補充，VSSConverter匯入TFS之SQL需求補充

 

這邊只是補充一些遇到的狀況：

 

問題：本機安裝的不是 SQL Express 該怎麼辦?

訊息：

TF60022:  Unable to connect to Microsoft SQL Server .\SQLEXPRESS. A network-rela
ted or instance-specific error occurred while establishing a connection to SQL S
erver. The server was not found or was not accessible. Verify that the instance
name is correct and that SQL Server is configured to allow remote connections. (
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Spe
cified)

解決方式：VSSConverter匯入TFS之SQL需求補充

 

撰寫 Setting File 所需要的小工具

 

小工具一：列舉出 VSS DB $/ 底下的目錄(Project)，請注意，列舉出來目錄是 $ATM，但是設定檔會需要 $/ATM 這樣子的格式。

 

SET SSDIR=c:\vssdb

C:\Program Files (x86)\Microsoft Visual SourceSafe\SS.exe dir

 

小工具二：刪除VSS DB 中不需要的目錄(Prject)，重點在於 -I-Y  ，

若執行過程中有錯誤訊息會出現 continue?(Y/N)，要一直按 Y 也很煩人，這個指令就很好用!!

 

SET SSDIR=c:\vssdb

C:\Program Files (x86)\Microsoft Visual SourceSafe\SS.exe Delete $/delete-me -I-Y

 

小工具三：UltraEdit or Excel

UltreEdit 可以用來行列編輯，另外 Excel 也可拿來產生設定檔，例如下圖：

公式也不難寫，例如C2這一格的公式為：="<Project Source="""&A2&"""   Destination="""&"$\temp\"&A2&"""></Project>"