how to move a database table from one server to another server database.This is performed
when I click a button in .aspx page like import the table goes and adds to the another server database in web application.
I want to transfer temporary table from one server to another linked server. I want to transfer it like how Bulk insert does. Right now I'm transferring row by row. It should do bulk transfer.
View 6 Replieshow 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 Repliesi have two servers s1 and s2
In s1 we hav an aspx page called test1.aspx
In s2 we hav an aspx page called test2.aspx
In test1.aspx i have a textbox and a button. I enter data in textbox and click the biutton.
Now the data that has been entered should be shown in a label in test2.aspx
test1.aspx and test2.aspx are in two servers...so how to do it ...
We have developed one Web Application which is running in only one server. Now client needs our application be in two servers. So if one of the servers down then another server should be working. We are using sessions in our application. Now the problem is how to transfer the session data from one server to another??
View 7 RepliesI have a class which implements IHttpHandler that is designed to handle image resize requests. It handles Urls like so [URL] Currently the handler looks for myimg.jpg on disk, cuts a 100x100 thumbnail (if it isn't already present) and redirects the client to the thumbnail like so Response.RedirectPermanent("/some/virtualPath/to/thumbnail.jpg");
This has been working great, but I would like to avoid forcing the client to issue a second HTTP request. Is it safe to do the following? Server.Transfer("/some/virtualPath/to/thumbnail.jpg") All the MSDN documentation talks about using Server.Transfer() to redirect to an aspx page, so I'm not sure if this is the right thing to do or not.
What is Web services? What is Web services? How can I Transfer the data from server to client and client to server using XML. Need one simple Example program(C# web Application) ...
View 1 RepliesI have a large dataset (35,000+ rows) that I need to export to excel and then let the user download. I have done this the conventional way (with a gridview), but the data has grown, causing a OutOfMemoryException on the web server.
So I thought, would it not be better if I can export the data into excel on the sql server, and then transfer this data to the web server.
Note that this is not a one-off job. This will be ran regularly (twice a month), but the user. Hence I need something that the user can initiate.
I would love to create a "daemon" which in specified time intervals will move-transfer any zip files uploaded by the users from a.example.com to b.example.com
From the info i gathered so far,
The daemon will be an .ashx generic handler. The daemon will be triggered at the specified time intervals via a plesk cron job The daemon (thanks to SLaks) will consist of two FtpWebRequest's (One for reading and one for writing).
So the question is how could i implement step 3?
Do i have to read into to a memory() array the whole file and try to write that in b.example.com ? How could i write the info i read to b.example.com? Could i perform reading and writing of the file at the same time?
No i am not asking for the full code, i just can figure out, how could i perform reading and writing on the fly, without user interaction.
I mean i could download the file locally from a.example.com and upload it at b.example.com but that is not the point.
I want to know the best way to transfer data from a view in Oracle database 10g to Sql Server 2008.
View 1 RepliesI have a requirement to fill the pdf file.
We are using Sql server and i want to transfer data from SQL server to pdf file.
How to write and deploy SSIS data transfer packages. ?
View 2 RepliesI have an update panel with a gridview. When the user hovers over one field in the gridview, a HoverMenuExtender pops up to display more detail of the row from the gridview. The gridview also has a button, that when clicked, uses server.transfer to pass some info via the previous.page method about the row selected.
I can't get these two to work together. Either the update panel will work with the hover menu, or the button in the gridview will work with server.transfer. Sys.WebForms.PageRequestManagerParserErrorException is the error
Found this article that talke about using Response.Redirect instead of Server.Transfer. But, that won't work for me because Response.Redirect doesn't work with passing data between pages.
[URL]
So, what I'm trying to do is figure out how to set a button in my gridview to be asynchronus, but can't figure out how to do that with this button from my gridview.
[Code]....
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
View 5 Repliesi have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
View 3 RepliesMay you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only
As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 RepliesIf I need to redirect a user from one page to another, should I use redirect or go with server.transfer? I'm assuming redirect. The idea is to give the users one specific URL and then have that URL redirect to the most current iteration of the page. For example, the user may have [URL] as the URL but the actual page served to them would be [URL]
View 16 Repliesprotected void btnCancel_Click(object sender, EventArgs e)
{
Server.Transfer("Fix_Details.aspx");
}
Server.Transfer is not redirecting the page. It stays on the page that the button was clicked on. The message is "Error on Page."I tried Response.Redirect and that didn't work either.
A first chance exception of type 'System.Threading.ThreadAbortException' occurred in mscorlib.dll An exception of type 'System.Threading.ThreadAbortException' occurred in mscorlib.dll but was not handled in user code
After banging my head because i could find where the exception came for and global.asax didn't get hit i found that it's from server.transfer and is a known bug. The alternative i read about is server.execute.However if i do this then the next page fires multiple javascript exceptions and a gridview i have is breaking of and the rows appear half at the left page corner and half inside the gridview!!
For now i just put a try catch on the server.transfer although the exception will not affect the application even if i don't use try catch. I also see that the exception is happening again even if i put try catch but with different dll: A first chance exception of type 'System.Threading.ThreadAbortException' occurred in App_Web_benglxq1.dll An exception of type 'System.Threading.ThreadAbortException' occurred in App_Web_benglxq1.dll but was not handled in user code Now what on earth is benglxq1.dll i don't know. What i know is that i'm leaving an exception to run and i don't like that. This is the js error when i use server.transfer btw: Microsoft JScript runtime error: Sys.ArgumentTypeException: Object of type 'Sys._Application' cannot be converted to type 'Sys._Application'.
I have one website running on one server and another web application running on another server. My web application asks for username/password to login into the system. I need to put a username/password field on my website so that user can directly login from website. how to transfer these username/password values to the web application running on another server?
View 3 RepliesI have a custom error handler in the global.asax's Application_Error method, when an error occurs I use the following code to transfer user to the error page:Server.Transfer("/Error/");
However without specifying the actual page name the code above breaks with "Error executing child request for /Error/" exception.So if I use Server.Transfer("/Error/Default.aspx") it works fine with no problems.Also using Response.Redirect("/Error/") works fine too, however we want to keep using Server.Transfer to retain URL displayed in the address bar when the error page is displayed so users can simply refresh the page to retry accessing the original offending URL.Would be grateful if anyone can comment on how to get the Server.Transfer method working without specifying the actual aspx page name.