How to Convert/Migrate/Move/Copy MSSQL Database to MySQL Database?

Scenario Your Company/Organization/Institute maintains certain data in MSSQL 2000 but now on suggestion of System Analyst or database administrator you want to move the data to MySQL 5.x. Questions? 1) How to migrate the data? 2) Do we need to recreate the complete database schema? …

Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part-IV

In Previous three parts I have explained about Transactional Replication How to configure Distribution Server How to create Publisher  Today in last part of this series I am going to explain how you can create the Subcriber to the Publisher which will complete the replication …

Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable

Sometime while connecting to MSSQL Server Configuration Manager it throws following Error Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable. Note that you can only manage SQL Server 2005 servers with the SQL Server Configuration Manager. Invalid namespace[0x8004100e] …

Error: SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name.

Sometime while setting up MSSQL Replication you will receive following error at the time of connecting Slave or Secondary Database Server.   Detailed Error: TITLE: Connect to Server —————————— Cannot connect to failover-db. —————————— ADDITIONAL INFORMATION: SQL Server replication requires the actual server name to …

MSSQL 2005 Error: Cannot recover the master database

Sometime due to some technical problems or uncleaned shutdown master database of MSSQL gets corrupted and while starting MSSQL service it throws following Error Application Log in Event Viewer shows following Error Cannot recover the master database. SQL Server is unable to run. Restore master …

Step by Step Guide to MS SQL 2008 Transactional Replication over Internet Part – I

Replication is can be defined as a process of copying or reproducing information between two or more resources to improve reliability, fault-tolerance or accessibility. Replication can be configured on LAN, WAN or on Internet for database where same data is copied and stored on multiple …

Unattended MSSQL 2005 Installation – Command Line Installation of MSSQL

Microsoft SQL Server is a relational model database server produced by Microsoft and it’s Installation is quite Easy using GUI where a user has to selects the options which he/she needs with the database server and install it. We can automate the installation procedure and …

Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part-III

After you configure the Distributor Server (Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II) now I will explain how you can create & configure the Publisher. Create & Configure Publisher 1) Select the Transactional Databases: Login to MSSQL Management Studio and go to  …

Find Table Count and Tables without Primary Key in MS SQL

Few days ago while working on MS SQL 2008 Transactional Replication I have faced following two issue 1) To find out the total number of tables to verify that Primary Server and Secondary server have same table count. 2) Tables without Primary key: After replication …

Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II

In previous article (Step by Step Guide to MS SQL 2008 Transactional Replication over Internet Part – I) I have explained replication and how transactional replication work. Now I am going to explain some pre-configuration settings which need to be done before setting up MSSQL …