migrate site to MOSS 07

SharePoint - Setup, Upgrade, Administration and Operation

- Previous
  - 1
    - Open Behavior Rules in InfoPath Hi, I have an InfoPath form which is published in MOSS. When I submit it, I save these values into a database. Is there a way to fetch those values from the database and display those values in the controls(by applying a rule or soemthing) I understand that if I save it in an xml file, it will open with the values in the saved file. There is another source which accesses the same data. So, if the data gets changed from the other source, I would still get the correct data, if I fetch directly from the database. I have configured an "Open behavior rule" to fetch data through a data connection. Now, how do I set those values from the data connection to those controls Another rule Would really appreciate any kind of help. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 2
    - Deleting Content Types Hi Purse, The problem is that I need to delete the content type just from one document library (list). The GUI will not allow me to do it and says that the content type is in use (within the doc library). It is not in use in any visible manner. Thanks, Mindy Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 3
    - Office Access 2007 'move to Sharepoint' problem Hi We have an Access 2007 db. We are trying to use the 'move to Sharepoint' wizard to move the db to a MOSS 2007 site. We get an error message after specifying the site and clicking 'next': "The site you specified does not support importing data from a Microsoft Office Access database. The site must be running Windows Sharepoint Services from Microsoft" At this point all we can do is cancel the wizard. Can anyone help with this Thanks Mike Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 4
    - Content rollup for tasks Hi ! There are several content rollup webparts, but I can't find anyone for rolling up tasks. tasklists may be spread out over a lot of sites, and if I want to display all tasks assigned to me, a content rollup for tasks would be needed. For a personal site, a content query webpart, which could be an alternative, is not shown, possibly not usable ( ! !), and anyway, can't see how that can be personalized. Any tips on how this can be achieved terje Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 5
    - How do I set up security on individual sites I have one application under which I have three different sites. I would like to set security so only certain people can see certain sites . I am sure this is probably simple, but I must have a huge brain cramp. Right now everyone can see everyone. I have created groups, created users but no where can I see where to allow UserA only to SiteA and userB to SIteB. There has got to be a way!! Thanks. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 6
    - Removing Items from List Box I am working Microsoft Infopath 2003. I am using a list box which is bringing data from a SQL Server Database. Can I enable my user to remove any item in the list box How can I send multiple values from the list box to the database Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 7
    - Restricting users from uploading all file types except one Does anyone know how to write a program that captures the upload event and checks the file extension (SSP) Videos, Blogs, Tutorials, Sceencasts, webcasts are more helpfull. Thanks; Amir Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 8
    - Sharepoint 2007 backup/restore Hello, yes i can, if i take all farm i get errors with SSO. can i do backup only with one part of farm TNX BR Grega Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 9
    - upload Document Size increase Thank You. Very Helpful Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 10
    - Custom webpart.. rounded corners Hey all.. I'm a graphic designer.. i make pretty pictures.. i've been thrown into the sharepoint deep end and i need some help. I've been searching around for a solution to a design mockup that we need to cut up and convert to sharepoint. The problem is rounded corners on webparts. Our client has this thing about rounded corners.. it's part of their brand image.. so we added rounded corners to the webparts on our mockup. So the question is.. is this possible http://www.users.on.net/~barillaj/dan_random/webpart_rounded.jpg I've seen a few css and javascript hacks.. but none that really apply to what i'm trying to do. Any help would be MUCH appreciated.. thanks. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 11
    - Workflow Template to WSS3.0 How to include the template which is created as a SharePointWorkflowLibrary Project in VisualStudio Workflow Designer to the SharePointServices Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 12
    - Incorrect display name We have a user whose display name in SharePoint (MOSS 2007) is coming up incorrectly. The last character of his last name is being dropped. I've gone through all the settings on his account in AD and verified that the last name is spelled correctly, and even looked at all the attributes of this user in ADSI Edit to make sure there wasn't some reference to the incorrect spelling. I've tried removing the user's rights from SharePoint, changing the user's AD display name to something that's purposely wrong, and then re-adding him to SharePoint. However, it continues to show the same, incorrect display name (and never the new, incorrect one). What's strange is that this user was also displayed incorrectly on our old SPS2003 server. I created a new SharePoint 2007 environment (no upgrade) and once again I'm seeing the same behavior. I assume that it's pulling the misspelling from AD, but where I've seen references to some utilities such as wssuserutil, but I'm not clear if that's compatible with MOSS 2007 or if it would help me in this situation anyway. Any thoughts Thanks, Jesse Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 13
    - Problems with FBA, please help That sounds like exactly what I've been looking for. I'll check it out now and see if it solves my users becoming disabled problem. Thanks, Evan Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 14
    - Trouble after B2tr Sorry but I don't understand. I really just need sharepoint to work again. How do I do this Thanks for your help, Rob Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 15
    - Update the Answer field of an existing listitem Hi, I'm trying to add an answer to the Answer field of an existing listitem. I can reach the item, but none of the updates are being done. I update the answer field like this : item["Answer"] = "NEW ANSWER"; List.Update(); This doesn't give any errors, but it doesn't do anything. Does anyone know how to update this Greetz ! Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 16
    - search is not working Have you looked at the search results in the SharePoint Central Administrator Look at the errors that are shown for your search content. The other place to check is the Event Logs - espeically the Application logs - for the server that performs the search services (e.g. the Index service). Loog for those that are red and have SHarePoint in their source description. Hope that gives you a few clues where to begin looking. Good luck! Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
- Next
  - 1
    - Troubleshooting "This Web Part Page has been modified since you opened it" error with load balancing working Someone asked for the proof the other day and I couldn't find it then either. Sorry but I am 100% positive! Nothing needs done in SharePoint though, should all be handled by your device. Shane - SharePoint Help Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 2
    - Sharepoint calendar on 1024x768 resolution The Sharepoint 3.0 calendar on our home page when viewed in resolutions 1024x768 or below does not fit on the page. It breaks the tables and puts a scroll bar at the bottom. This is not functional! We've searched for an answer and tried several fixes. If we change the width of the web part it adds a scroll bar at the bottom of the calendar. Any suggestions appreciated. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 3
    - task list can be submitted although mandatory fields are not filled in I am working in MOSS 2007 and SPD 2007. I have created a workflow in SPD that involves a task list item. This task list item has a mandatory choice field. Unfortunately MOSS does not check if the field has been filled in by the user. The user can click "Complete Task" and the task will be completed although the mandatory field is still empty. The web form shows an asterix * behind the mandatory field and it looks all as if it should work. However it doesn't. Does anyone have an idea how to get arround this Thanks. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 4
    - Never could get that DataView connection to SQL Server to work..... After many woes I eventually got SSO to work with both SharePoint designer and the BDC. Forever, i had two different MOSS servers I was trying to configure with SSO and both exhibited various problems, one of which was your error. Eventually what fixed it on one server was to re-create the encryption key and then re-start the service. Then suddenly everything started working. Since I had essentially configured everything in parallel, I figured i'd messed something up along the way and it had been cached in some way, but when doing this fix on the second box, it didn't help. It was still was giving me an authentication error in my logs every time i tried to connect. I found that in order to get it to work, I had to delete everything SSO and start over, configuring SSO in this exact order: Make sure the SSO is running under an account that meets the requirements outlined in the Central Administration Help. Start the service. In the Central Admin SSO area, Configure the settings under Manage Server Settings. Make sure these accounts match the requirements in Central Administration help too. In the Application definintion section, create an application definition using Windows Authentication. I used a group account. You should be able to leave the rest as is. You'll choose which group account to use in the next step. Go to the Manage account information for enterprise application definition settings. Select your new definition and add the Group account you want users to authenticate to. This is the client-end account. The user trying to connect to the db must be in this group. Click Set. In the Logon Information, enter the Username and Password that SSO will use to connect to the DB. I don't know if this gives you any feedback if you enter the information wrong. There is little feedback when you get it right, i know that. Enter the info carefully and click OK. That should be all you have to do. In SharePoint Designer, connect to a SQL datasource using SSO. In the SSO box, enter the SSO Application ID, "Username", and "Password". I think that if you get something wrong along the way, it sort of messes everything up, and the whole thing doesn't work unless you start over. That is how it seems to work for me at least. This was one of the biggest PITAs so far for me and my relationship with MOSS. unfortunately, now that i successfully got that working, i can retrieve data, but cant' actually write back to the DB using SharePoint designer and SSO. I have a post here about that. Good luck to you, hope this helps. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 5
    - Workflow modification form I have added and eventdrivenActivity to my eventhandlers activity section and in this eventdrivenActivity i have added an onworkflowmodified acitivity. I did this by click with the right mouse button on the evenhandlingscopeactivity and then clicking on view event handlers. I dragged the activity's here. i first removed the onworkflowmodifiedActivity from the whileActivity wich made the listenactivity unnecessary(removed that to). I also changed the settings of onworkflowmodifiedActivity to correlate to my token and modification form. I still don't see the modification link on my worklfow status page. I have run the microsoft modification sample wich DOES show the modifylink. So something in my workflow is still not configured correctly but i can't find out what.... Any clue of what it could be Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 6
    - Sharepoint Server harddisk capacity critical Hi guys, im using a MOSS in a 500Gb harddisk. currently it is at critical stage - about 90% of the total capacity is being used. Is there a feature in MOSS that capable of migrating my current datbase into a new machine(increased harddisk capacity) reply is appreciated Thanks Jay Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 7
    - problem publishing webpart thanks for the reply but it definitely doesn't use any third party dll. The dll was written originally in visual studio 6 without any third party applications. the only references in there are to the CDO.Message class. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 8
    - Search database? Is anyone able to restore the search database to a different server I'm having some troubles with it. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 9
    - Save a Site Template including sub-sites Start by saving each site (top level and each "different" subsite) as a template. Next, by using the "createSite" method from the sdk, create a simple app that will allow you to create a top level site based on a specified template (top level site's not subsite's template). Add in the functionality to loop through the site creation code as many times as there are subsites, but each time pass the new parent site's url (in this case it will be the newly created top level site) to the createSite method (which will now make each of the successive runs of the code create a "subsite") and passing in the template of each subsite. Additionally you'll have to add code that will update the parent site's top level navigation bar and quicklaunch bar to add navigation to the subsites. We've had to implement something similar due to the shortsighted-ness of the "save site as template" concept. Not sure why they didnt think that folks wouldn't want to save a full collection of sites (top level and associated subsites) as a template, but then I suppose thats's what the idea of "site definitions" are for...although I'm not sure just how you could solve this issue through that approach either. At any rate, there is no built-in method to save site+subsite(s) as a site template other than developing your own "coded" solution...which really isn't too bad (it's not too much code to make it work). -Dink Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 10
    - Indexing MDI files from Office Document Imaging [upon previewing, i know the fonts are all screwy here...just copy and paste or squint . I'll work on reformatting this after I get some sleep. I've written this for WSS 3.0, but if you're using MOSS 2007, the steps are virtually identical. You might just need to do a little control-F in regedit to get to the appropriate key location (i think its under OfficeServer instead of Shared Tools - something like that)] To Install support for PDF / MDI / TIF / XPS indexing in Sharepoint 3.0 Sorry for the delay - yeah MDI indexing was crucial for me as well as the filesizes are much more compressed. The search filter settings are located in 3 different locations, but are all virtually identical in nature - they all relate to specific registry keys. First off, you need to make sure the MDI filter is installed in SQL server. You need to install Microsoft Document Imaging from the Office 2003 or Office 2007 installation - under Additional Tools if you do a custom installation. Then in SQL Server, run the following query to determine installed filters: select document_type , class_id , version from sys.fulltext_document_types. This will return a list of the extensions filtered along with the clsid of the components handling them. If you have an entry for .mdi files, then copy the clsid to a location you can reference later. If you do not see .mdi listed but you have MODI installed, you need to run the following sql query to enable the iFilter (something about Microsoft not signing the component so sql blocks it by default): Code Snippet exec sp_fulltext_service 'load_os_resources', 1; exec sp_fulltext_service 'verify_signature', 0; go After this, re-run the first query to verify .mdi files are now associated with the correct component (should be clsid: 62160CBE-AFCB-4795-9B68-DDE5BA6D2524 ). With this done, time to modify the registry. With WSS 3.0 installed, you want to navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0 - and do an export for backup purposes of everything under this key. Navigate to the sub key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Applications\89a9d417-5231-45b7-a9f5-08d4e043d8ce\Gather\Search\Extensions\ExtensionList - you're CLSID may differ from mine, but the structure should be similar. In the extension list you will see a list of keys listed by number with extension types as the data. Add the extensions you're interested in indexing (for me I added keys 38,39,40 with data of "pdf","mdi","xps" respectively). Next navigate to the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Setup\ContentIndexCommon\Filters\Default - Here is a key called "DefaultExtList" that should currently tell what extensions are handled by sharepoints default iFilter. I made sure to remove "Tif" and "Tiff" from this list as they need to be handled through the MODI filter. Next navigate to the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Setup\ContentIndexCommon\Filters\Extension - Here you find how sharepoint maps extensions to the components to handle them. Insert keys following the existing layout by adding your extensions along with the CSLID for your MODI component (should be 62160CBE-AFCB-4795-9B68-DDE5BA6D2524 ). On a side note, if you pulled out the SQL iFilters list in the first step, feel free to setup PDF indexing along the way - just poing the extension PDF at the CSLID found in your SQL Server. Also, take care to point TIF and TIFF files to the MODI component as well. Last step here, I went to the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Setup\Filters - and followed the existing structure to tie my TIF and PDF extensions to the appropriate MIME-TYPEs ('application/pdf' and 'image/tiff' respectively). With this done, do another backup of this entire part of the registry in case things need to be redone. While I originally thought these changes would do the trick, after a server reboot I found out that all the registry settings I modified were reverted back to the original settings automatically (I was pretty pissed). If this happens, you can simply execute the backed up .reg file to merge the changes you made right back in. After my registry was put back to normal I figured there must be saved copies of this part of the registry somewhere (sharepoint must do some comparison against factory default settings and modify if it notices changes/corruption). The copy of the registry is actually held in your SQL Server database for sharepoint as a binary field in a table. Specifically, in your Search Database under the table MSSconfiguration is a record with the field Name='RegistryBlob' and BigValue= the binary data containing the original registry information. I wrote a little .net application that retrieved the binary bytes from this record and wrote them to the filesystem. Open up the file in a text editor and you will see it is just another .reg file. You need to make the same updates you made to the actual registry in this file, so that upon comparison Sharepoint will not recognize any differences. This is were cutting and pasting from the backup .reg files I mentioned previously will make this very easy. Upon finishing the file updates, modify your application to then read the bytes from the file and update the existing record with the new binary data. Lastly, upon searching around the hard drive I found another file located around the Program Files\Common Files\Microsoft Shared\etc... called 'registryblob.reg' that was another 3rd copy of the same registry information. I simply copied over this file (after making a backup) with the same file I was uploading in binary back to the MSSconfiguration table. With this done, you should be good to go. Again, we're making the same registry modifications but in 3 different locations. Once in the actual registry, once in a .reg file around the hard drive, and once in a binary file held in the Search Database table MSSconfiguration. Reboot the server, upload a .mdi/.tif/.pdf file(s), wait 10 mins or so and do a search against content in the file. Should be jackpot. The following is the code I used to write the binary into/out of the table (pretty basic stuff): Code Snippet 'Read binary to local file Dim sql As String = "SELECT BigValue FROM MSSConfiguration WHERE Name = 'RegistryBlob'" Dim sqlcom As New SqlClient.SqlCommand(sql, SqlConnection4) sqlcom.Connection.Open() Dim bytes() As Byte = sqlcom.ExecuteScalar sqlcom.Connection.Close() Dim fs As New System.IO.FileStream("c:\db_original.reg", IO.FileMode.Create) Dim bw As New System.IO.BinaryWriter(fs) bw.Write(bytes) bw.Close() fs.Close() MsgBox("done") 'Write binary back to database Dim sql As String = "UPDATE MSSConfiguration set BigValue = @data WHERE Name = 'RegistryBlob'" Dim sqlcom As New SqlClient.SqlCommand(sql, SqlConnection4) sqlcom.Parameters.Add(New SqlClient.SqlParameter("@data", SqlDbType.Binary)) Dim fs As New System.IO.FileStream("c:\db_modified.reg", IO.FileMode.Open) Dim br As New System.IO.BinaryReader(fs) Dim data() As Byte = br.ReadBytes(fs.Length) br.Close() fs.Close() sqlcom.Parameters("@data").Value = data Try sqlcom.Connection.Open() sqlcom.ExecuteNonQuery() Catch ex As Exception MsgBox(ex.Message) Finally sqlcom.Connection.Close() End Try MsgBox("done") Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 11
    - Setup Error: This product requires ASP.NET v2.0 Hi! MS support had no quick solution but i got it working by myself. I uninstalled IIS, reinstalled IIS, repaired ASP.NET (dotnetfx3_x64.exe) and then i could change the ASP.NET v2.0 IIS WSE from 'prohibited' to 'allowed'. After that, WSS setup went just fine! Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 12
    - Can not get UDF to work with COM Addin Thanks for your help. As soon as I copied extensibility.dll and PIA on the SharePoint server it started working. I have one more question. I am trying to use existing dll (written in C) which already has UDFs. I found an article �� Developing User-Defined Functions for MicrosoftR Office ExcelR 2007 and Excel Services �� ( http://officeblogs.net/excel/UDFs%20for%20Excel%20client%20and%20server.doc ) I was wondering if there is any way that my managed dll containing UDF functions can call existing unmanaged dll to get additional functionalities Or the only alternative I have is to create managed UDF wrapper for existing dll. Thanks again. Aleksandra Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 13
    - SharePoint - Excel Services - Mobile Browsers What documentation is out there that discusses Mobile browser support for SharePoint's excel services feature. I am testing out some senerios, but have been unable to display excel documents through the excel services viewer or through the dashboard web parts. Does anyone have any information on this I am looking to consume BI Charts and Graphs via excel services in a mobile device. Thanks. Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 14
    - Help me for KyewordQuery in wssv3.0 Hi all, Please give a code snipet how to use KeywordQuery object model programmatically in web part programming Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 15
    - Outlook/MOSS integration - missing the obvious? Hi - we are looking to synchronize a MOSS calendar list with the default Calendar in Outlook 2007. SharePoint insists on creating a new Calendar for every list I synchronise but does anyone know a way to change the destination Calendar so that the event items in the SharePoint Calendar list are actually synched with my default Calendar. This must be a common business request for organisations looking to use the Outlook/Sharepoint integration features in 2007. For example I've given someone access to my Calendar to see what I'm up to but if the SharePoint Calendar items are syched to the separate Calendar that MOSS created, this other user can't see all the additional appointments set for me in the SharePoint Calendar list. I could provide access to the MOSS generated calendar and ask the user to cross reference but if you multiply this by a hundred users all with different Calendars created by different Sharepoint lists this becomes impractical. I'm sure I'm missing something obvious - can anyone help Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies
  - 16
    - WSS 3.0 Integration in ASP.NET 2.0 Website Hello everybody, I am a newbie for Sharepoint and i got the requirement which is something like "Integrating WSS 3.0 in to ASP.NET 2.0 Website application", to make it clear i have one website which is currently running on ASP.NET 2.0 which has web 2.0 based functionalities. In that i would like show up the power of WSS 3.0 which is basically want to leverage the new features like Wiki etc. into my Web 2.0 application. In my web 2.0 application, i have one section called "KNOWLEDGE BASE" where the customers or employees written or stored KB articles which has rating of the article and team colloboration, workflows, etc.. I think , i am not sure THE SAME KIND of SCENARIO is already available in WSS 3.0 which might like WIKI ...(i am not sure) ...looks like this... I want to embed the WSS feature into my web 2.0 application, so that it got the complete user experiences.... Please help me in this regard. Thanks, Kathir Tag: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07 SharePoint Products and Technologies

M. Hassan Raza

Hello All,

We have two environments, one is SPS 2003 and the new one which is MOSS 07 Ent Ed environment.

We have a lot of WSS sites in SPS 2003, from which we have two sites which we want moved ot the new server farm of MOSS 07, can anyone please tell me how to do that.

Thanks

Hassan

http://mhrhap.spaces.live.com

Re: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07

Neil Hodgkinson (MSFT - PFE)

Probably the simplest way to do this is to isolate the two site collections you want to migrate into their own database. You can do this using stsadm.exe but if you need more info I'll provide it.

Once you have the sites in their own database you can then PRESCAN the database and assuming no errors the next thing to do is to backup the database and restore it to the MOSS farm sql server. Onc you have it here you can use a contentdbattach process in stsadm or from the central admin > application management > content database

This process will upgrade the database and sites within it to MOSS.

Hope that helps

Re: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07

M. Hassan Raza

Cant the backup from SPS 2003/WSS 2 environment of that site collection and a restore to MOSS 07 environment will work

I knew that DB Attach would be possible but thing is that DB Attach would upgrade all the sites in the other farm whcih we dont want, we only want specifically two sites in that one Site Collection.

Thanks.

Hassan

http://mhrhap.spaces.live.com

Re: SharePoint - Setup, Upgrade, Administration and Operation migrate site to MOSS 07

Neil Hodgkinson (MSFT - PFE)

you cannot take a previous version backup and restore into MOSS.

This is the reason why I said you should split the sites into two databases, one database containing the site not to be upgraded and one containing the sites for upgrading. This way you only upgrade the sites you choose to.

you can split the sites into separate databases using stsadm.exe and the backup/restore options