Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transferring User Defined Datatype to new server !!!!!! Expand / Collapse
Author
Message
Posted Friday, August 21, 2009 5:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970

Hi,

can any body tell me
how can i script out the user defined datatyped from one database to deploy them to another server's database ?


Thanks



Bhuvnesh


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #774915
Posted Friday, August 21, 2009 5:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
Have you tried this?

Right click on the database -> Tasks -> Generate Scripts...
Post #774933
Posted Friday, August 21, 2009 6:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970
thanks


it worked for me


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #774962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse