|
I have an asp.net application hosted in localhost with backend as sql express. An sql server 2008 database with same structure is hosted in a remote server. I have to synchronize these two databases. What is the best way to do this? Can I do it with sync framework? Please suggest me a solution for this.
|
|
|
|
|
How about Backup the remote server and Restore it to the local? Or you could export the data from the remote server and import it back in locally - there are a number of ways to accomplish that. There are a number of other ways that also come to mind but those are probably the easiest and quickest (depending n the size and disposition of the databases).Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
The process should work in every 1 or 2 hours. The synchronization process should be done automatically. The backup and restore will be difficult in this situation and it will take more time. Is there any other solution apart from back up and restore.
|
|
|
|
|
Well it was good that you mentioned everything in the first post otherwise I might have posted an innapropriate answer.
How about scheduling a Sql job that will do the work for you? Sql Server Jobs[^]Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
Actually I do not know much about sql job. I will try it. Thank you so much for giving the details. If you have any other ideas please give that one too. I'm going to check with jobs. Once again thank you.
|
|
|
|
|
Hello,
Here are the steps I have taken to set and retrieve a session value:
1)
In the page load event of the login page, I have placed:
Session.Remove("DB");
2)
Then when there is a successful login, in the page load event of the first page that appears i.e. the default.aspx I have placed:
Session["DB"] = strDB; //where strDB is a text
3)
Then I need to retrieve this session value from within a class file and this is how I am retrieving it in the constructor of the class
string strName = (string)System.Web.HttpContext.Current.Session["DB"];
Question:
Most of the times there is no problem but sometimes I get an error on step 3) above and it says object reference not set to an instance of an object.
Do you see anything wrong please?
Thanks
|
|
|
|
|
arkiboys wrote: reference not set to an instance of an object
are you writing you page load code in,
if (!Page.IsPostBack)
{
//your code here
}
|
|
|
|
|
Can't see anything wrong with the code itself, but this is probably not the best way to be doing this kind of thing.
IMO As long as a user is logged in, the Session value should be there, and you should only remove it when they have logged out.
- rather than doing Session["DB"] = strDB; on PageLoad of Default.aspx, do it on the login page, when the user has entered their credentials and clicked the login button
- rather than doing Session.Remove("DB") in PageLoad of the login page I think you should do Session.Abandon() when the users click on the logout link.
|
|
|
|
|
|
The solution to this task is simple.
protected void loginButton_Click(object sender, EventArgs e)
{
// your code for authentication goes here
if (myUser.IsAuthenticated())
{
Session["username"] = usernameTextBox.Text.Trim();
Response.Redirect("~//Default.aspx");
}
else
messageLabel.Text = "Authentication failed: Invalid username or password";
}
protected void logoutButton_Click(object sender, EventArgs e)
{
Session.Abandon(); // or Session.Remove("username");
Response.Redirect("~//Logout.aspx");
}Tunsten
|
|
|
|
|
arkiboys wrote: Most of the times there is no problem but sometimes I get an error on step 3) above and it says object reference not set to an instance of an object.
This is because your session is expired and the object no longer exists. so everytime when you read a session variable you need to check wether its there or not.
string strName;
if(System.Web.HttpContext.Current.Session["DB"] != null)
strName = (string)System.Web.HttpContext.Current.Session["DB"];
else
Response.Redirect("Your login page");
if you open the page and wait until your session expires you will get that error every time (default time of session is 20 min).
take a look at the article which 'Brij' has suggested.
|
|
|
|
|
Hi All,
I have hosted my asp.net 2.0 project in a general webserver where we have found a lot of problem like session expiry, view state, machine key etc. To execute my project on such server I had to do configuration which is required for asp.net project running on web farm. so I thought my server could be web farm.
But the server guy has confirmed that they have not done any cofiguration for web farm and they say its a simple web server.
I am totally confused if my server is not web farm then why its need configuration like web farm. why my code is not running there.
Any body can suggest me whats wrong I am doing.
Any help would be highly appriciable.
Thanks
Rohit
|
|
|
|
|
You just need a Windows Hosting with ASP.Net 2.0 nothing special, Do you know wether you have windows hosting with ASP.Net 2.0 ? because if its just simple HTML hosting or Linux hosting, you cannot run ASP.Net application on it.
What kind of problems you are facing ? List out the exact error messages here.
|
|
|
|
|
we have a dedicated server windows 2003 and all required software for asp.net project is installed.
we have used .net 2008 provided Ajax which doesnot work there gives the javascript error "sys is undefined" but when I specified the machine key on web.config then its works.
We got the error about the view state we had to made the enableledViewStateMAC to false in web.config.
We got the session expire problem in "InProc" case which was solved when i used StateServer
I just dont understand what wrong i did there.
|
|
|
|
|
Ask you about the heroes of a web development technical issues, how to use Flash technology to achieve dynamic image switching, that is, multiple pictures into a cylindrical rotating display, each user is always seen in front, a picture, the effect like the following website show: http://www.monex.co.jp/
|
|
|
|
|
Hi All,
Can I write HTTP Handler for the folder which does not exist? for example if I write "http:/localhost/website/CompanyName" it should be redirected to the specific page.Thanks,
Shahzad Aslam
|
|
|
|
|
|
|
Yes, that is the easiest way. And it will work if page not found. In your question you asked in different way, that you need to redirect if the url is like , so I thought you are looking for URL Rewrite 
|
|
|
|
|
can its possible to popup a message window ( like alert ) to all online website users from admin side ? if yes , giv me eg !
Regards.
|
|
|
|
|
|
|
|
You can also check this.
Hope it's helpful!Tunsten
|
|
|
|
|
If I understand you correctly you want to be able to click a button on an admin page in your site and have that cause everyone who is currently browsing your site to get a pop-up.
You would have to do some work on every page in your site and have it check for an application variable or a database value or something. But even with that, unless you had something in your pages that causes them to auto-refresh constantly, it isn't going to display immediately. It would only show up when they do something to cause the page to reload.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
