Link to home
Start Free TrialLog in
Avatar of Natchiket
NatchiketFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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 ?
Avatar of udaya kumar laligondla
udaya kumar laligondla
Flag of India image

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
ASKER CERTIFIED SOLUTION
Avatar of udaya kumar laligondla
udaya kumar laligondla
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial