November 3, 2011 at 11:59 am
we are using sql server 2005,actually frequently we have to restore production database to acceptance environment ,sometimes database in acceptance have more tables than prod database. in that case i just use import\export wizard or select into command to transfer extra tables in acceptance to a temporary created database in same server, but while doing that size of the table in temp database is less than actual one.So ,while looking table structure there is no index’s,primary keys,foreign keys etc. could ypu please post your suggestion.
November 3, 2011 at 12:13 pm
We had similar requirements so I wrote a .net utility that can transfer various objects from one database to another, or to renamed tables in the same database. I used the SMO namespace to select and script out the objects and create the objects at the destination, then BCP to transfer the raw data using SQL server native mode.
It is very fast moving very big tables and built as a command line option so we can use it scripts to automate repetative tasks. It does not attempt to script and re-create FK constraints on tables being copied though (for obvious reasons).
The probability of survival is inversely proportional to the angle of arrival.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply