varsha2
asked on
copying bulk data from one sql server to other
I have to copy about a million of records from one sql server (sql 2005) to another every day. I tried using the ssis package, but ended up locking the source table.
What would be the bestl way of doing this with out any affect on the performance of the source database.
Could I use the backup created on the source database to copy data to the dest. I wnat to copy only one day's worth of data
What would be the bestl way of doing this with out any affect on the performance of the source database.
Could I use the backup created on the source database to copy data to the dest. I wnat to copy only one day's worth of data
ASKER
The query had (nolock), but since I am querying over a million of records sql server escallated it to a table lock
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be deleted for the following reason:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned and is now flagged for deletion.
If there is a valid solution, please OBJECT and indicate the comments that are, or would otherwise lead to, a solution.
Use the specific format https:#axxxxxxxx for comment ID(s).
Also, please don't object simply because the author did not respond to your comment. While we understand this is frustrating, unfortunately we cannot force the author to return to the question. Unless you feel you have presented a valid, verifiable solution we'll simply delete the question.
Experts-Exchange Auto Deleter
No comment has been added to this question in more than 21 days, so it is now classified as abandoned and is now flagged for deletion.
If there is a valid solution, please OBJECT and indicate the comments that are, or would otherwise lead to, a solution.
Use the specific format https:#axxxxxxxx for comment ID(s).
Also, please don't object simply because the author did not respond to your comment. While we understand this is frustrating, unfortunately we cannot force the author to return to the question. Unless you feel you have presented a valid, verifiable solution we'll simply delete the question.
Experts-Exchange Auto Deleter
Did you try my recommendation. It has always worked for me. Let me know if I can be of any help.
The method above will always work done correctly. I can provide further assistance if needed.
For example
Select * from table (nolock)