Copying data

Nov 16, 2011 at 3:01 PM


Is it possible to copy BE data from one database to another?  The foreign key constraints seem to make it so that only way to migrate data from a dev database to production is by doing an entire database copy, which I can't do, since the prod db is 2008 R2 and dev is just 2008.

Please help.