View Complete Post
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.
I need a detailed description/ procedure to accomplish the work.
Tanks in advance.
If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.
MSDN Magazine July 2009
How can I upload a file to a database (with as little code as possible!) along with a desciption of a file and then search through the descriptions to retrieve the appropriate files. Then how can I click on one and download it.
I am not a very advanced programmer and would like full step by step code if possible not just a link to a website.
Thank you very much
Hello All,I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery.
Now I want to deploy it on the remote server using Web Deploy method.
Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error:
Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).
Can anyone have the solution of this error?
Thanks in advance....
I have a web form where user can upload image and store to SQL database. (SQL tables has a relation like one title has multiple images fields).
Title: <asp:TextBox ID="txtTitle" runat="server" Width="300px"></asp:TextBox>Image Name:<asp:TextBox ID="txtImage" runat="server" Width="200px"></asp:TextBox><asp:FileUpload ID="FileUpload1" runat="server" />
Title: <asp:TextBox ID="txtTitle" runat="server" Width="300px"></asp:TextBox>Image Name:<asp:TextBox ID="txtImage" runat="server" Width="200px"></asp:TextBox>
Title: <asp:TextBox ID="txtTitle" runat="server" Width="300px"></asp:TextBox>
<asp:Button ID="btnSubmit" runat="server" Text="Submit Information"
protected void btnSubmit_Click(object sender, EventArgs e)
//to store image into sql database.
string strImageName = txtImage.Text.ToString();
if (FileUpload1.PostedFile != null &&
FileUpload1.PostedFile.FileName != "")
byte imageSize = new byte[FileUpload1.PostedFile.ContentLength];
can i upload my pdf or word file to oracle/SqlServer database table ?
how to take backup of database from local system to public ip system?
Database on local system..
that backup file should be on that public ip system..
Please help me ASAP
Thanks in advance.