SQL Server - How to export data From one Server to another sever by SQL Query

I want to make a tool for my website for updating data from local server to web server.

plz help How to export data From one Server to another sever by SQL Query

Its quite difficult and pain to write a query for this as you need to go through al the tables and do the stuff..

Instead you can make use of import export features as discussed here..

http://msdn.microsoft.com/en-us/library/ms141209.aspx

You cannot use a query to do this.  You may want to write some script to do this, or export your data to a csv and import.  The other option is to backup and try to restore it onto the new server.  Once it is restored you will have full access to all the data.

if you want to transfer data from one server to another, you can use Database Publishing Wizard software by using this you can make a script of database with table and insert query with data, you had stored in that.

now mostly server support query interface, you can simple copy the content from the script to server query interface and transfer your data from one server to another.

 http://technet.microsoft.com/en-us/library/ms141209(SQL.90).aspx

Hi

I think there is way in sql server in built.i have answered, here

http://www.eggheadcafe.com/community/aspnet/7/10108665/how-to-update-webserver-d.aspx

Thank you
http://www.codegain.com