Step 1: Open svn Command prompt from Visual SVN Server Manager
Step 2: Svnadmin Create c:\Reposotories\NewProjectRootName Step 3:Create a new folder inside the new NewProjectRootName using repo-Browser Step 4:Svnadmin load c:\Reposotories\NewProjectRootName < c:\Repositories\proj.dump
now command prompt will start dumping files to your filesystem, wait it to finish.
It's easy to insert update the Binary data from a .net application (web/windows).
But If you need to insert/update or copy/paste the data which is already there in the database then it's not possible using the SSMS Table Editor (see attached image), it would give an error "The changed value in the call was not reognized as valid. .Net Framework Data Type: Byte Error Message: You cannot use the Result pane to set this Field data to values other then null".
Solution Use the SSMS Query editor to do this, i.e. update TableName set BinaryColumnName = BinaryData
Note: The binary data value should not be enclosed between any single quotes
While working with Entity Framework (EF), sometimes the EF doesn't recognize the columns returned by the Stored Procedure. Reason 1) If the db procedure is using temporary table (e.g. #tempTable), EF don't recognize the MetaData from the procedure. 2) If multiple select ... statements exists in db procedure. Solutions Before executing procedure or beginning of db procedure set the FMTONLY to ON like below line: SET FMTONLY ON This will force EF to read the metadata from Temp tables Disadvantage There would be performance issues with approach because the way EF read the metadata from temp tables is to execute them multiple times. Workaround Instead of using the temp tables, create table variables and use them to store data temporarily. While using this option you don't need to set the FMTONLY setting. Performance Using the table variables will be faster than FMTONLY option. Find more detailed information at http://munishbansal.wordpress.com/2009/02/18/set-fmtonly-on-useful-in-tsql-ssis-packages-for-using-temp-tables/ Thanks