.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Migrating to Production server

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
Hi All, We have a dev server in which we have two databases which we are maintaning for 3yrs.The tables in these databases have data for 3yrs like in millions. now we are planning to migrate it over  to production server.the dev  server will be with us but the whole databases and jobs and everything from dev server should be migrated to the new production server. can anyone guide me the step by step process how to migrate the dev server to production server. I need to prepare a document for the production people to get this done. Thanks in advance.


View Complete Post


More Related Resource Links

Migrating aspnet tables to dev server - having issues

  

Hi,

We're trying to migrate a one of our apps to our dev server for testing and development, but we're having problems with the membership functionality. We can add users, but there seems to be a disconnect with roles. We can query the aspnet_users table and find the new user in there, but when we query the aspnet_usersinroles table, that user id is not present.

We're also unable to run the Roles.GetUsersInRole("somerole") method. It returns 0 records. When I run Roles.ApplicationName, it returns the correct name, so .NET should be passing the correct app name.

We're just a little baffled. If anyone could shed some light on what could be the issue, we would appreciate it.

Thanks! :)


Deploying custom Web Parts on SharePoint 2007 production server

  
I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?

Problems migrating 32-bit SQCLR routine to 64-bit SQL Server

  
Greetings. I have written a 32-bit SQLCLR routine that uses the 10.2g Oracle.DataAccess library to draw Oracle data through SQLServer queries. (This tool was necessary due to issues we had with the Oracle native client). This has been in place and working without issue for about two years. This tool required the independent registration of about six (?) other system assemblies, which worked without incident (various warnings about using unsupported assemblies aside). We use permission_set = unsafe for all these DLL's. We are now in the process of migrating this tool to the newer 64-bit version of SQL Server 2008 on our Windows 2008 Server R2, and we have a problem. We took our list of base assemblies from the 32-bit installation and registered them against the Framework64 version of the same DLL's on the SQL Server 2008 box, and that step worked. We found that the Oracle.DataAccess library we had could not be registered in the 64-bit SQL Server because it was an x86-specific version. We then discovered that the 64-bit version of the Oracle.DataAccess library was available only in the 10.2.0.4 update patchset, which we obtained and installed. Unfortunately, adding the assembly now fails: When I attempt the CreateAssembly on the 64-bit Oracle.DataAccess.dll within the 64-bit instance of SQL Server, I now receive a new error, to-wit: "Assembly '

Application_Error not firing on Production server.

  
 Hi, I am trying to setup my application on Production server. Whenever any error occurs, we are redirecting to a specific page in Application_Error Event in Global.asaxThe code in Application_Error Page_________________________________________ string _rawUrl = Request.RawUrl;if (_rawUrl.IndexOf(".aspx") == -1 && _rawUrl.IndexOf(".gif") == -1 && _rawUrl.IndexOf(".jpg") == -1){       string[] _arrRawURL = _rawUrl.Split('/');       Server.Transfer("~/UserHomePage/Default.aspx?UserProfile=" + _arrRawURL[_arrRawURL.Length - 1]);}  It is getting fired Locally. As it was not working, I tried the alternative as belowMade Custom Errors to On in Web.config. and in IIS, in Custom Errors section, under 404 Page I gave the ErrorPage file Name and written the above code. But still  it is not working.Kindly help me out!  Thanks in Advance. Chaitanya.

Development and Production Server software information for Sharepoint 2010 ??

  
Need to ask my IT Team to get me softwares for Development machines to write code / develop sites which we can give to end customers for deploying in their Sp2010 Production farm . W.r.t to that i have following questions : For Development , a) Which Windows Server 2008 OS version is sufficient - Standard , Enterprise , R2 ? b) Which SQL Server Version is sufficient ? c) Which VIsual studio version ? d) Which Sp2010 license version ?   From Production environment perspective , have following questions - a) What should be a recommendation to client for Production Server - Widows 2008Server sp2 or R2 ? SQL Server 2008 Server Sp2 or R2 ? Which is better and why ?  

Migrating changes from the Development to Production Site (SP2010, SPD and Visual Studio 2010)

  
Trying to find the best (least error-prone) approach to updating a live site containing content (based Documents and Tasks mainly) with changes. This got to be a common issue - a Development environment containing new features needs to be migrated over to production but the existing data and workflows with the associated tasks should be preserved. I found this thread http://social.msdn.microsoft.com/forums/en-us/sharepointdevelopment/thread/2C524797-9737-4D11-BE19-3E407C5C83CE which seems to provide a rather negative take on a tool-based approach but it's for older Sharepoint. Anything improved since then?

What is the best and easiest way to add SSL on a production 2007 SharePoint server

  
I already have a 2007 SharePoint Server up and running http://www.abcde.com/sharepointsite1 1) What is the best and easiest way to have https://www.abcde.com/sharepointsite2 in addition to have http://www.abcde.com/sharepointsite1 running as is? 2) Should I setup another web application all together with another IP address with port 443? Would that be the easiest? I can have something like this https://www.abcdefg.com/secure1 3) Please advise and comment. 4) If I don't create another web application, what are my alternatives? Thanks for the help

Moving a feature from dev server to production server

  
Hi, I have created a feature in my sharepoint development server. The development server is one location and the production server is in another location. After testing the feature in the dev server, I am not sure how to move the feature to the production server. I want to move only that feature, that is newly created and not the whole site. How to move a feature from dev server to the production server. Please explain the steps in detail, if possible. Thank you

error in emailing moudule frm production server

  
in my asp.net application i have a emailing module& i have 2 web server 1) is the development server  2) production serverdevelopment server  has all the source files & the code where i can debug  2) production server has the published files the problem that i am getting is when i am sending the email thr; development server it works fine without any error but when do the same process thr' production server i get error , the code files , teh database etc all is same - i am not able to trace the error as i am not able to debug on th eproduction system , and the mail is not senthow & where do i check out & solve the issue 

Making a copy of WSS3.00 from Production server to Development.

  
Dear All, I have a WSS3.0 production server which use MSSQL2008 database on Same box.Now I am planning to install a new server for developement purpose with same settings as production.Is it possibile to make a copy of production WSS on new Development server? It would be a great help if somebody can explain me the steps how to configure a copy of datas from Productin to Development incase if this option works!   Thanks to all in advance Regards Jo

web service is not working on production server

  
hi i am calling the webservice from acrobat javascript. it works very well in development server. but when i put the same code in production server, it doesnt call the webservice. And doesn't throw any error. Help me .

How to deploy and configure ssis packages using sql server table in testing server and production en

  
Hi We have three environments (development, testing and production ) I have to configure and deploy the ssis packages using sqlserver table in different environments(development, testing and production).   Three environments database structures  are same But database names are different like (DEVSERVER,SITSERVER,UATSERVER) We have 14 packages and one master package. In master package we called all 14 packages question1 First time i will deploy all (master and 14 packages). If i modify one package we need to deploy all the packages or single package deployment is enough    Please help me thanks in advance          

Migrating ASPNET Role/Membership Database to New Server

  

Hello,

I have an existing ASPNET role/membership database created on SQLExpress 2005 (WIndows 2003 Server). I created it under the .NET 3 framework many years ago using the aspnet_regsql.exe application in full GUI mode. 

I am setting up a new Windows 2008R2 server with .Net Framework 4 and SQL Server 2008R2. I don't want users to have to recreate accounts or create roles, etc.

So...

1. Should I backup the current database and import it into the new system, and if so do I even need to use the aspnet_regsql.exe application. (If so which version do I use, different aspnet_regsql.exe files exist in different directories (i.e., FrameWork, FrameWork64)


2. Should I just run aspnet_regsql.exe on its own and then somehow try to import the current data into those tables.


I am concerned that if I just import somehow the roles within SQL server will not be created properly. 

thanks in advance,

mitch


Deploying wsp files in production server

  

HI,

I am using wspbulder. I created EventHandler project and builded the wsp file. I had got a wsp file, after building the application.

How to deploy this is in production server( which is a different machine).

Could someone please provide links on working with wsp for feature and Event handling and deploying the same in production server.

Thank you


Clone production Sharepoint 2010 server to Developmet environment - steps? help?

  

Greetings all,

I'd really appreciate some thoughts and suggestions about how to make a clone of our Sharepoint 2010 Production environment that we can use for testing and development.

At the moment, we are likely to have two different servers (Production is a much more expensive, powerful server) for the scenarios; so if we make a direct clone, the Windows OS files would be upset.

Would it be enough to simply copy the Windows Shared files into the Dev system (taking all modifications with it) and the db into a cloned db?

If not, what are the things we'll have to consider, and/or has anyone accomplished this yet?

Thanks for your tips and suggestions!

--Dave


Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend