tags:

views:

17

answers:

1

I'm trying to copy SQL database from one server to another.

Please tell me how to use Transfer() method without loosing constraints in the target database.

I've tried different parameters including

 CopySchema = true;     // and 
 CopyAllSchemas = true; //and even 
 CopyAllObjects = true;

and still this damn thing is losing all the constraints.

Help me, pls!

A: 

Ok...

 transfer.Options.DriAll = true;

helped. But now It's leaving all triggers behind

Ike