• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

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 ?
0
Natchiket
Asked:
Natchiket
  • 2
1 Solution
 
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
 
udaya kumar laligondlaTechnical LeadCommented:
sorry it is Database Publishing wizard
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now