how copy changes in my developing sql server to the main sql server

Hi

I have two sql server; one is the main server which is under use and the other one is on my pc for developing.

I work on my developing version and have problem on copying changes to the main server. For example sometime I create and change more tables, stored-procedures, functions and insert some records to tables and it so hard to copy my changes to my main server.

can anybody suggest a good way to this issue?

thanks

September 15th, 2015 1:45am

There are multiple ways

1. Use generate scripts wizard to script out objects and then apply them onto the other server

https://msdn.microsoft.com/en-us/library/bb895179.aspx

2. Create a database project in SSDT and use it to deploy the objects

https://msdn.microsoft.com/en-us/library/hh272687(v=vs.103).aspx

3. Use Transfer SQL Server Objects task in SSIS to move the objects to other server

https://www.mssqltips.com/sqlservertip/2064/transfer-database-task-and-transfer-sql-server-objects-task-in-ssis/

Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 2:02am

I (try to) use scripts to modify my databases on the development machine and save those scripts. Next run the scripts on the 'live' server.

Added benefit is that I learn not to rely on UIs when working in Microsoft environments;) Might be easier for me than for others as I started in the Linux environment and MySql and did everything on the 'command line'.

September 15th, 2015 2:11am