is there any way to transfer data of database (of just one table ) to a another database i mean from local to remote
Printable View
is there any way to transfer data of database (of just one table ) to a another database i mean from local to remote
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 ?
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
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.Quote:
Originally Posted by ERUM
Do you have ftp access to the remote server, where you can place your exported file? SQL Server 2005 provides an import - export utility.
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...
yes i done it with dts package