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

Asked By DC ATTRI on 16-Jul-09 07:25 AM

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

Santhosh N replied to DC ATTRI on 16-Jul-09 07:39 AM

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

re - Web Star replied to DC ATTRI on 16-Jul-09 07:40 AM

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

RE - Ravenet Rasaiyah replied to DC ATTRI on 16-Jul-09 08:25 AM

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