Configuration :: Move A Local Development Database To The Production Server?
Jul 28, 2010
Problem: I need to move a local development database to the production server without any of the test data.
I am running SQL Server Express 2008 and SQL Server Management Studio 2008.
To create my ASP.NET Membership 2.0 system I created the DB initialy and ran aspnet_regsql.exe
I then added my own tables manually to store additional information.
I adjusted the web.config file with an application name.
When I ran a sript the application ID name was created and populated in the aspnet_Applications table. My script created a new member created and added to the admin role. Ok so everything go so far.
Now I want to move the local DB to the server. I know the connection string and can change this in the web.config.
My hosting company doesn't provide restore, so I don't think I can backup and restore
Q 1. What would be the best way to move the database across. Bearing in mind I need to clean the database out of test data.
Would it be just generate an SQL Script for the database and run it as a query on the server? And if this is the best way then do I need to set the permissions for the ASPNET user?
Q 2. What is the best way to clear out the data in the local database.?
View 1 Replies
Similar Messages:
Jul 20, 2010
I am rather new to asp.net but I have built a couple of apps that do not require users to login. am having some problems moving my secure .net application from my laptop to a production server, however, and I am hoping someone can help me. On my laptop my application's user authentication functions as it should, but when I move my application to a webserver I get an assortment of errors. Forgive me if these questions are a little basic. My first question is this. In a production environment do I move the ASPNETDB.MDF file in the App_Data folder to my SQL server? Is it OK to rename it to something more descriptive?
View 4 Replies
Jul 14, 2010
I have used a dll named MARCEngine, which is used to read Marc data. I use a method named MARC2MARC21XML which converts a normal marc file to an XML file.
The problem is it works great on my local IIS, but when I upload it to the production server, it only generates the root node and not the child nodes.
Here is a snippet of my sample page :
[Code]....
Asp.net has the permissions to access the files geneated.
View 1 Replies
Mar 22, 2010
I am wondering the best way to change my connection string based upon which server I am accessing.
Essentially, all of the development is done on our local machines - once we think it is working, we upload it to our development server. In these 2 instances, I want my application to go off of our "dev" connection string for the SQL database in the web.config.
However, once it is published to our production server (for an internal application), I would like the connection string to point to our live db.
I am using the N-Tier model by Imar Spaanjaars - and have it setup like he suggests - In my DAL I have a class called AppConfiguration -
In this class I have a public readonly property ConnectionString() which returns the connection string in the web.config.
This is in an individual class library. What I would like to do is something similar to:
If server is localhost OR devstring return devString else return productionstring
View 1 Replies
Jan 21, 2011
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...
I have created some of my tables also ....in ASPNETDB ..
In my local PC the site was running fine ...
But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
My hosting provider connection string ..
<add name="ConnectionString" connectionString="Data Source=69.16.253.19;Initial Catalog=usa_data;Persist Security Info=True;User Id=user;Password=pass" providerName="System.Data.SqlClient"/>
My hosting provider gave me the connection string to connect to the SQL Server 2005 but it doesn't work...
I don't understand why my site was running fine using the production SQL Server 2005 in my local PC when I include ASPNETDB.MDF file in App_Data in my local pc only ..if I remove file ASPNETDB.MDF from App_Data of my local pc ... the site stops working ...
Can anybody tell em how to fix this ... !! I am very tensed since last 3-4 days
View 1 Replies
Jan 12, 2010
I want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
View 3 Replies
Mar 19, 2010
How can I test an application that I am publishing to a remote provider's IIS7 hosted site, with the VS2008 development server that is built in with VS2008 on an XP Machine?
My membership/roles work perfectly up on the remote host. On ths hosted IIS7 site when I try to access a secure directory it redirects to login, and I am able to login, however when I launch (debug - F5) from VS2008, it will provide that folder/resource, no questions asked. Same build, config, etc... nothing has changed.
I am running XP, and local IIS version installed is 5.1.
My guess is what is happening is that the new format required in the web.config is configured properly for IIS7 deployment, which is why it works remotely, but when running locally through VS2008/XP it is running with an older version on IIS and does not recoginize the new tags.
View 3 Replies
Sep 22, 2010
When I run the application using the Web Developer it works fine. However when I run it using local IIS I get the following error:
The resource class for this page was not found. check if the resource file exists and try again. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The resource class for this page was not found. heck if the resource file exists and try again.
Source Error:
Line 81: private void PopulateLanguageList()
Line 82: {
Line 83: DropDownListLanguage.Items[0].Text = (string)HttpContext.GetLocalResourceObject(
Line 84: "Default.aspx", SelectLanguage, Thread.CurrentThread.CurrentCulture);
Line 85: }
Stack Trace:
[InvalidOperationException: The resource class for this page was not found. Please check if the resource file exists and try again.]
System.Web.Compilation.LocalResXResourceProvider.CreateResourceManager() +4038050
System.Web.Compilation.BaseResXResourceProvider.EnsureResourceManager() +23
System.Web.Compilation.BaseResXResourceProvider.GetObject(String resourceKey, CultureInfo culture) +24
System.Web.Compilation.ResourceExpressionBuilder.GetResourceObject(IResourceProvider resourceProvider, String resourceKey, CultureInfo culture, Type objType, String propName) +32
System.Web.HttpContext.GetLocalResourceObject(String virtualPath, String resourceKey, CultureInfo culture) +56
APPortal.Login.PopulateLanguageList() in c:inetpubwwwrootAPPortalDefault.aspx.cs:83
APPortal.Login.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootAPPortalDefault.aspx.cs:20
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
System.Web.UI.Control.OnLoad(EventArgs e) +132
System.Web.UI.Control.LoadRecursive() +66
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428
View 1 Replies
Apr 15, 2010
I have seen the examples on how to switch between connections strings for development and production enviroments. My web.config also calls out a connection string for <roleManager and membership><providers>. Can this be setup to switch between the two connection strings?
View 1 Replies
Sep 1, 2010
Here is my problem: I have created a login form on my local machine. I have tested it on the local machine and it works fine. But when I push it to production it doesn't work.
I set-up the web config file so that the system uses the production database even from my local machine. I used the Web > AspNet Configuration tool in Visual Web developer to add a user to the production database. I used Sql studio management studio to confirm that the user was in the production database and not just on a local database. I have removed all references to the local database. I even deleted the entire app_data folder on my machine so that there was no chance that I am using a local database.
To create the login, I dragged a login component onto my Login.aspx page from the toolbar in visual web developer.
Why can I log in just fine on my local machine, but when push everything to production and I try to log in as that user I get the error message "Your login attempt was not successful"
View 3 Replies
Jun 17, 2010
I never host any web application on the development server.I learn the tutorial how to copy the file using file zilla FTP client.But question is raised, how can I link my sql server machine to Http development server.And how can I configure my database on the development server.What at all DNS setting is require?
Finally All I need is , upload a web application and SQL server database on development server.
View 1 Replies
Jul 8, 2010
how to transfer my data from devlopment server to production server ,i have already records exist in my database if i go for script then how can i transfor record in script i can transfor only table ,procedure and views.I am using SqlServer 2005.
View 2 Replies
Jan 2, 2011
I am using this code to pass variables from ASP.NET application to HTML Application:
[Code]....
The above code is run from page_laod event, and I am making some development changes on the Development Machine (say
http://eutdev02/ehrmd).
After the ASPX page is loaded, and I debug the javascript in the HTML (F12 under IE8), and can see the Cookie is found in the browser.
But, when I open the target HTML/Javascript web page (which will read the cookie prmStaffID), but the HTML Page is on the production machine (separate server say
http://prod01/Attendance.html), the Cookie is not found !!!
It seems to me that Cookies will persist only on one IIS Server, and will not be global.
Question:How I can persist the Cookie on the Client Machine regardless of the the Server Machine ?
For testing purposes, I want to send the cookie to the client from teh Development Server, but the target application is under HTML/Javascript, and I want to be able to read the same Cookie using Javascript.
View 5 Replies
Feb 11, 2012
I have a functionality working ( functionality for making controls visible / true false ) on my development system having windows 2008.
But the same is not working on production server having windows 2003 on IE.
View 1 Replies
Jan 28, 2011
[Code]....
i want to get data from database of field Name and Gender, and then display it in Label name and gender. when i click save it move to next record and display name and gender that next record.
View 3 Replies
Jan 14, 2011
Is there a way to view incoming requests to a local ASP.NET development server? I'm making wcf service calls from a android app to a local development server. Something goes wrong somewhere along the way, and I need to view what data the server recieves.
Edit: The android app is local too... in an emulator.
View 2 Replies
Jul 5, 2010
can anyone point me to some differences hosting a website on some remote server VS running it locally on dev environment.The reason why i am asking is, If I run my website locally it works fine no exceptions, runs smooth. But when deployed on a remote hosting server. Its like a nightmare to me :(very often i get object Instance not set to instance of object..... I am ok with the error message, But the same situation should happen locally, thats what bothering me:D
View 2 Replies
Mar 13, 2011
I have an MVC web application, the urls like following in my views folder:
<img src="../../Images/Delete.png"/>
are working on my localhost, but when I deployed the application on production server, they stopped working and when I use single ".." instead of double "../.." , they start working on production server.
View 2 Replies
Apr 16, 2010
It somethimes happens that, when I use PrinceXML to convert a webpage to a pdf, the local ASP.NET Development Server stops working...It popups the message "ASP.NET Development Server stops has stopped working"
View 4 Replies
Feb 2, 2011
I am using the Ajaxpro dll in my development server working fine.If i am going to deploying the code from production server its not working. I am getting the Ajaxpro is undefined..
View 2 Replies
Mar 17, 2011
I have deployed simple application on production server it just update sql server table via update query.
The problem is That when I run that app on development machine it updates table on remote server but after deploying it on production server and accesing the url on production server/and development machine my code doesn't execute and thus it don't update table.
I have created virtual direcotry and configured app with specific application pool which is custom based Asp.net account.
View 7 Replies
May 5, 2010
In Production Server there are Issue with Writing in one of File. File not getting Write.I have give all the permsion even added EveryOne give full permsion.It's working on a windows 7 But Not working on a Windows Server 2008.R there any extra permsion need to apply ??
View 1 Replies
Jul 6, 2010
Sometimes I would like to be able to update during day time my ASP .Net application. I noticed that quite often updating DAL's (.xsd files) that are in used will block my application (and users). The only way, I found to recover, is to restart IIS but my users do not like it.
Is there some more clean way to update an online server without disrupting the users ?
Could I identified the DAL which are in used and the users using them, so that I could somehow disconnect only these users (My application uses Windows authentication).
View 1 Replies
Jan 11, 2011
We have had some problems with using a unmanaged DLL file written in Delphi. (Unable to load dll - not found...)The following code solved the problem on my local machine:
[Code]....
1) The elusive DLL is copied to the ASP.NET temporary files folder2) To check this we get a list of files from that folder.3) The needed function is called with DLL-import.1 & 2 works perfectly - both run directly from Visual Studio 2010 and when uploaded to a webhotel3 works perfectly local, but causes the remote host to think a little and then return a HTTP 503 Service Unaviable error for the next few minutes...
View 1 Replies
May 3, 2010
I have moved my entire project to my test server, everything went as planned with the exception of a couple of items. The main one that I'm having troubles with deals with subfolders of the website. On my local computer I created a my project then I created a sub folder, Secure, so that I can work with the security on the sub folder via ASP.NET configuration. I wanted only certain users to be able to access the folder, which works on my local computer, but when I try to navigate to it on my test server, I get a 404 error. I create two Roles on my local computer, but don't know if I'm able to make those roles on my test server. Is there a way to make those roles so that the security that I have on the sub folder will allow them to be displayed. Not certain why I get a 404 error.
View 3 Replies
