Blog Archives

How to move SSRS reports from one server to another and Assign Data source through SQL script

First follow below link to download SSRS reports https://gallery.technet.microsoft.com/scriptcenter/SSRS-all-RDL-files-from-00488104 Now download SSRSBuddy tool form codeplex.com https://ssrsbuddy.codeplex.com/ Run the exe with admin privilege. Enter valid Report server URL and select Data Source and Folder Also, browse and select reports to upload.

Posted in SQL Server

SQL Server 2005 replication (Snapshot/Transactions) on different server

Open SQL Server Management Studio Right click on “Replication” & click on Distributor properties Go to publisher tab & Add “SQL Server Publisher” Enter Server Name & Authentication information and click to “Connect” Click on “…” to set the other

Posted in SQL Server

Installation & Configure SQL Server Compact 3.5 SP2 for SQL Server 2012 on Windows 2012

Download Microsoft SQL Server Compact 3.5 Service Pack 2 using below link http://www.microsoft.com/en-sa/download/details.aspx?id=5783 Install both 32-bit and 64-bit versions of Microsoft SQL Server Compact 3.5 Service Pack 2 on a 64-bit Computer Run the Setup Accept License agreement Click “Install”

Posted in SQL Server