question

omi avatar image
omi asked

bat file on window server to insert the data in to database

I took only data backup from SQL table and need to insert same data in another database which have same table structure. Please let me know how I can do that with bat file on window server. Backup data is stored in .rpt file with order_20160321.rpt name.
data-import
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How did you create this backup .rpt file? Did you use the 'save results to file' option from a query window?
0 Likes 0 ·
Yes, I added parameter in bath file to save the output in .rpt file. But I am thinking to take incremental backup for selective tables. Can you please tell me how I can make bat file to take incremental backup of selective table for daily basis ?
0 Likes 0 ·

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
Try exporting en importing the data with [BCP][1] [1]: https://msdn.microsoft.com/nl-nl/library/aa337544.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks working fine
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.