How to propogate changes in SQL server

Hi I'm delevoping a SQL server solutiuon for a client.  The work is done locally on my PC/laptop.  For all the new objects I've created on my development server, how do I go about transferring them to the client's sever without manually recreating them through the studio manager?  Is there a straightforward way of generating a script or something ?
LVL 17
NatchiketAsked:
Who is Participating?
 
udaya kumar laligondlaTechnical LeadCommented:
sorry it is Database Publishing wizard
0
 
udaya kumar laligondlaTechnical LeadCommented:
use Database Scripting wizard from Microsoft and you will be able to script all the objects and data to a file. use the file to deploy the script
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.