DataSource Controls :: Data Restore From Production To Testing Environment?
Mar 3, 2010
Current process:
Whenever we have an issue in production, we restore DB backup from our nightly sql backup files in our testing environment. This way we get all data from production.
New Requirement:
Instead of restoring the db which takes upto 2 days, they want to do only selective restore based on few parameters. Requirement is to a build a new ASP.NET page in our application with few inputs. On submit button click, I should select data from prod and insert into testing environment. This involves opening new sql connection.
View 2 Replies
Similar Messages:
Apr 29, 2010
my SEL Server name is changed. I have a backup file. Now I want to take the data in the older file. So how can I restore the old data in the new SQL server which name is changed?
View 7 Replies
Nov 29, 2010
I developed a web page using asp.net 2.0 and ajax toolkit on my laptop on Windows 7 and IIS 6. I have my ajax/atlas toolkit DLL in my bin. The updatePanel works fine and does not postback my page. But when i hosted my website on a dedicated server the page postback totally like i have no updatepanel/ajax in my page...
I am using : Windows server 2008, IIS 6Ajax 2.0 installed on the server. I don t understand what is the difference with windows server or IIS or something else?
View 5 Replies
Jun 11, 2010
I have a procedure in asp.net web site that gives strange result sometimes, I'm thinking to add some code to track it. My question is, in the production environment, is there any way that I can get the calling stacks like the one in the exceptions?
View 1 Replies
Apr 9, 2012
In my development environment, my CSS loads perfectly. But when I publish the files to the server, the CSS no longer loads.
Originally, when I had this problem, it was because I was denying access to unknown users for all directories. It was also occurring in both environments.
When I fixed that, the CSS started working just fine. But when I publish it to the server, it no longer works.
The website appears to function. I can log in, navigate pages and everything. It's just that the CSS doesn't work.
I checked the permission on the directory and it has access to NETWORK SERVICE, the admin account and IIS_IUSRS.
View 5 Replies
Jan 20, 2011
I have this website with english and portuguese support. In localhost everything works fine and the content is translated based on the querystring parameter named "lang". This chunk of code makes the trick in every page:
protected override void InitializeCulture() {
SetCulture(); } private void SetCulture() {
var logger = Util.GetLogger();
string lang = Request.QueryString["lang"];
if (string.IsNullOrEmpty(lang)) { lang = "pt-br"; }
string sessionLang = (string)Session["lang"];
if (sessionLang != lang) { Session["lang"] = lang;
} logger.Log(string.Format("Culture {0} found",lang));
UICulture = lang; Culture = lang;
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(lang);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(lang);
logger.Log(string.Format("Cultura {0} set", lang));
base.InitializeCulture(); }
Thanks to the logger I can say for sure that this method is called in both cases (production and localhost). I have two resources files in App_GlobalResources folder:
-WebSitemapGlobal.en-us.resx;
-WebSitemapGlobal.resx;
View 1 Replies
Apr 29, 2010
When I try to run my ASP.NET app from my development environment I get the following error message: Compiler Error Message: CS1502: The best overloaded method match for 'mmars.Printing.printFunctions.SetPrintSummaryProperties(mmars.contextInfo, ref mmars.Printing.printObjSummary)' has some invalid arguments.
When I publish and run on our production server I don't get this error.It seems to compile fine when I build from the build menu (in fact if I change the second argument of the bolded function call below, i get a compiler error in visual studio), but now i've suddenly started getting this error message at runtime. So another question I have in addition to getting rid of the error is why is the .NET development server even trying to do JIT compilation on my project if it is already compiled into a DLL?
Printing.printObjSummary myPrintObj = new Printing.printObjSummary();
Printing.printFunctions.SetPrintSummaryProperties(ci, ref myPrintObj);
printObjects.Add(myPrintObj);
Also, though there are no warnings at compile-time, when I get redirected to the page with that first compilation error there are many warnings like the following:
Warning: CS0436: The type 'mmars.MMARSSummaryDataItem' in 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot3dad423c40569048App_Code.b0rgpkzr.4.cs' conflicts with the imported type 'mmars.MMARSSummaryDataItem' in 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot3dad423c40569048assemblydl37179c19a345f948c_ece7ca01mmars.DLL'. Using the type defined in 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot3dad423c40569048App_Code.b0rgpkzr.4.cs'.
What's the deal with that? Is the webserver complaining about name conflicts in the source file and dll resulting from the source file?
View 2 Replies
Feb 21, 2011
I have read some articles about the new enitity framework and I think it looks very cool from a development perspective.
considering a production environment loaded with data. How does one apply changes to the model? You cannot regenerate the model and in most large organizations, database changes are executed by DBS's and not developers. In such situaitons, it is the role of the developer to develop delta-scripts that the dba can execute.
My experiense with Hibernate (Java) and the like is that you have to pay double when using such frameworks.
View 2 Replies
Oct 1, 2010
Is it OK to use threading.sleep in an intranet web application to display AJAX loading (in production environment)? Off course, the application works fine without it but all works too quick for the end user or even a developer to notice any difference.What is the recommended approach ?
View 1 Replies
Jul 3, 2010
I am developing 2 Applications. One WebForms and the other is MVC. How can i secure the code such that when i deploy them to the clients production environment, they cannot be simply picked up, copied and repackaged by someone else?. I simply need a way to protect my intellectual property. Can this be done in Visual Studio 2010?
View 1 Replies
May 6, 2010
I am dynamically generating script code to return transaction data to Google Analytics using their ecommerce script. The code that generates the script is fully tested and functional on my development machine and when I view the page code the script, along with any values that were passed to it, can be seen above the </form> tag. Happy days, or so I thought. For some reason the code is not being generated when I test it in a live, hosted environment. I cant figure out why this is the case as the code is quite simple. I simply generate the script code and register it on the client side (see code below)
//Capture the transaction data for analytics ecommerce tracking
//Generate the necessary script code
string strAnalyticsEcommerceScript = Analytics_Ecommerce_Script_Creator();
//Register the script on the page
Page.ClientScript.RegisterStartupScript(this.GetType(), "AnalyticsScript", strAnalyticsEcommerceScript);
The page in question is called "Order-Successfull" and is where customers are sent to when they have succesfully payed for an order. On this page:
-The order is added to the orders database table
- The customer is emailed an order confirmation email
- The google analytics script is generated and registered
The Sequence is as follows:
[Code]....
Whats really interesting is that if I move the Analytics script creator code before the code that sends the emails, the script is generated and can be seen when I view the page code. If I do this, however, the emails do not get sent. If I lay the code out as per the code I have inserted in this post, the emails get sent but the script code is not placed on the page.. The code to that actually sends the emails is quite standard:
[Code]....
View 2 Replies
Oct 18, 2010
I got the following error message:
There was an error executing the query. Please check the syntax of hte the command and if present, the types and values of the parameters and ensure they are correct. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
But when I run the query through Management Studio, I can get the result.
There are no parameters for this query either.
View 1 Replies
Jan 4, 2010
i m using these command for backup and restore sql database
BACKUP DATABASE [db_report] TO
DISK =N'db_report.bak'
WITH NOFORMAT, NOINIT, NAME = N'Report-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
RESTORE DATABASE [db_report]
FROM DISK = N'db_report.bak'
WITH FILE = 1,
MOVE N'db_report' TO N'C:db_report.mdf',
MOVE N'db_report' TO N'C:db_report.ldf',
NOUNLOAD, STATS = 10
but i want to set backup drive name with today date and time yani my i will set drive D:db_report010320100910am if u will see theres is db_reportMonth(01) Day(03) Year(2010) Time(09:10am) and when i want to restore then ask me which one u want to get restore
View 2 Replies
Apr 23, 2010
I want to restore .bak files from a server directory into database. The problem is it should behave automatically. Whenever a .bak file will be uploaded in that specified directory of the server that file will be restored. It may happen by using sql procedure which will restore all the .bak file which it will find at a certain time in that specified directory. Or, it may happen by using asp.net program which will run exclusively on server and call a sql procedure to restore a backup file whenever a backup file will come in that specified directory. But I am not getting how to figure out this ideas programetically.
View 2 Replies
Apr 3, 2010
i am using sqlserver 2008 express.
i have a problem here, unfortunately i deleted "Manually" some important tables from my database, now i need to retrieve those tables,
i didnot take a backup for those tables,
can i retrive those tables or roll back delete process?
View 1 Replies
Feb 17, 2010
how can I achieve this using the SQLdatasource control? I'm using the VB language. What controls/commands should I use to have a backup and restore function on my website?
View 2 Replies
Jun 16, 2010
restore a master database from production to test server.
The reason to do this because I need to test and evaluate some login in master database.
I tried to restore master database to test server, but I got some errors regarding about user databases are not exists in test server. I don't want to restore user databases, I only need master database for evaluate user login.
View 1 Replies
Jun 17, 2010
I need to restore the database daily. I have a BAK file in shared folder. I have to restore it from my machine. I have used the below script to restore the database but I am unable to restore it. Its throwing error. I have shown the script and error what I got when I execute my Store procedure.
CREATE Proc GetRestoreDBS
(
@BakPath varchar(1500)
)
[Code]....
View 5 Replies
Jul 6, 2010
I have one database in local server...
What i need is i need to get a backup of my database with one click of asp.net button click with the names as of todaysdatewithtime.bak format..
as well i need to restore using asp.net on button click...
View 13 Replies
Jul 11, 2010
I have an SQL 2008 R2 database on an X86 machine that I have backed up a database from. Now I want to restore it to an SQL 2008 R2 instance on an X64 machine and keep gettting format errors (attributed to restoring a higher version of database to a lower database instance ie 2005 to 2008). On inspecting the databases I find the X86 is version 10 and the X64 is version 9 (which is supposed to be the 2005 database)...are there different versions of the same DB for different software platforms?
View 3 Replies
Feb 20, 2010
1. i have created aa database named "qraghul" which contains two tables. i want this database to backup from my system and restore it to the host server or any other system. how i can do it.
2. suppoose if i backup and restore it to any system or server. whether i have to change the connection string in my application eg Data Source=QUANO-462F6EB27;Initial Catalog=qraghul;Integrated Security=True
bcoz my server name is QUANO-462F6EB27 whether i restore it to any system. i need to change the server name?
View 4 Replies
May 4, 2010
In our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
View 1 Replies
Jun 15, 2010
I have searched and could not find any article related to "How to implement Certificate Security in
production environment".
I could able to Create sample certificates for client and Server on my local machine and was able to authenticate my client app with the certificates . These certificates are test certificates.
How do I do this in Production. We have a domain certificate from GoDaddy which resides on the server. How do I create a Client Certificate off of that.
View 2 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
Mar 12, 2010
In the development environment, in SSMSE > MyDatabase > Security > MyUser > Database role membership I have checked db_owner to allow me to build the database.
Now I am copying the database to the production environment I would like to lock the security down tightly. In the past (with classic ASP applications) I have only checked db_datawriter and db_datareader and, in Securables, checked Execute Grant on the stored procedures.
In Database > Securables I add my stored procedures and check Execute/Grant for each of them and click OK. When I return to the securables page the stored procedures are no longer listed.
I have noticed that nothing is listed in Effective Permissions and I think it should list Execute. If this is the problem, how do I add Execute to the Effective Permissions list?
View 1 Replies
