[RESOLVED] export data from one database to another

[ERUM]

is there any way to transfer data of database (of just one table ) to a another database i mean from local to remote

[nagasrikanth]

Yes of course..You should have.. But, How do you want will differ the solution/answer.. What DB exactly you are dealing with.. And how do you want to deal with it (Automatically/Manually).. If Automatically, what Tecno you are using ?

[ERUM]

i m using sql server 2005 and there is database for example database1 and
another database named database2 i want transfer data of table1 in database to table1 of database2

[ERUM]

keep in mind that datbase1 is at local and database2 is on server

[abhijit]

keep in mind that datbase1 is at local and database2 is on server

One method of doing this is to export the database and then import it at the remote location.

Do you have ftp access to the remote server, where you can place your exported file? SQL Server 2005 provides an import - export utility.

[nagasrikanth]

You can use SQL Server Import&Export utility to do this job if you want it to do manually.

If it is a repetitive task, Keep a job of Import&Export Script and schedule it using SQL Agent.

If you want to do it programatically (like C#,vb), then there will be a different approach based on language you choose...

[ERUM]

yes i done it with dts package