Home > IT Answers > Development > Update one database from another database with ASP.NET
Ingineer
5 pts.
 Update one database from another database with ASP.NET
ASP.NET, Database programming, Multiple databases, Web development
I want to update my database from another database when it change.Thank for your answers 
						

Software/Hardware used:
 					
 
					
					
ASKED:  
						February 20, 2009  9:13 AM 
					
 
											
UPDATED:  
							February 20, 2009  1:23 PM 
						
						
									
 
				
 
			
 

		

		
	
			

				
			

		

		
		
		

			

								
RELATED QUESTIONS

				

					
				

							

		

		
		


	

	






 
	

	
 
		
 
			
	
			
 
			
 
			

			
	
		

	
 
	
 


 


	
 
		
 
		
	
			
 
				
 
				
 
					
 
						
 
											
 
							
 
								
Answer Wiki:
 
								
			
									

		Assuming that you are using SQL Server you can use an UPDATE statement like this using the remote objects three part name.

<pre>UPDATE OtherDatabase.dbo.YourOtherTable
      SET Column1 = LocalTable.Column2
FROM LocalTable
WHERE LocalTable.Column1 = YourOtherTable.Column4</pre>	

	

		
 
			 
			 
			 
		
			
	

	
 
		
	
 
	
							
								
 
								

									
 
										Last Wiki Answer Submitted:  
																					
											 February 20, 2009  12:33 pm 
										 by  
										
																				Denny Cherry   64,505 pts.
																				
 
										

											All Answer Wiki Contributors: 
																					
											Denny Cherry   64,505 pts.																			

										
To see all answers submitted to the Answer Wiki: View Answer History.
										
 
								


								
  
								

 
							
															
						


					

				
 
				
 
			
 
		

		
		


	
 






			


	



	







	


	

		
RSS - Discussions Help

		
Discuss This Question:

		
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

		

						

					
					
					
					
				
			











	

	

		


	
	
	
	
	
	
	
	
	

	

 

	
	
	


	
	

		
	


 








				

		

		

	

			
 
			
 
				
 
					
 


	

 
 


	 	
 

 
	
 
		
 
			
 
			 
		
 
		
When posting questions its always helpful to tell people what software you are using.  SQL Server, Oracle, DB2, Access, MySQL, etc.


 
	
	

 
	
	
	
Denny Cherry
 
	
 64,505 pts.