Copy/Export conditional data From Local DB to Remote DB

Question

Post reply

Copy/Export conditional data From Local DB to Remote DB

sanjayasamantaray

SSC Veteran

Points: 293
More actions
November 25, 2011 at 1:18 am

#252550

I need to copy/export new data of one or more table from a local SQL database to a hosted server database which is structurally same.
Can some one suggest the ways to achieve it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sql_dba123 SSC Eights! Points: 853 More actions · Answer 1

You can try one of these options:

1. Use Import/Export wizard

2. BCP out from source and then BCP IN in the destination

3. Use OpenDataSource

sanjayasamantaray SSC Veteran Points: 293 More actions · Answer 2

Hi ,Thanks,

I can not use import and export wizard since

it is a manual process.

In my case there will be lot of clients.Each client will have a database and Client needs to upload data to the server. So only new datas of few tables should be appended in remote database and it should be an automated process.

Can you put more light on BCP Considering the above situation with example.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

Nan82 (11/25/2011)
You can try one of these options:
1. Use Import/Export wizard
2. BCP out from source and then BCP IN in the destination
3. Use OpenDataSource

OR Try something new & advanced Overview (Replication)

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

tommey152 Right there with Babe Points: 772 More actions · Answer 4

sanjayasamantaray (11/25/2011)
Hi ,Thanks,
I can not use import and export wizard since
it is a manual process.
In my case there will be lot of clients.Each client will have a database and Client needs to upload data to the server. So only new datas of few tables should be appended in remote database and it should be an automated process.
Can you put more light on BCP Considering the above situation with example.

If u want to use BCP,Try the below link

http://sqlfool.com/2008/12/bcp-basics/[/url]

_______________________________________________________________

Need help? Help us help you.