Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-14 : 08:09:45
|
| sqlbalaji writes "Hi I am trying to copy couple of tables (including data) from production to staging. I want to carry out this using a batch script if any is available. Is there is a way to do this at one step. I dont want to use DTS because of the following reasons.1. It will try to create the security / user permissions in the destination database. If there is no user, then DTS will fail.2. When there is change in schema in source DB, then the changes are not automatically picked up by DTS.I would appreciate if any one can figure out how to do this. Its kind of very urgent and i need helpThanks in advanceBalaji" |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
Bulk Insert Script 