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? 3) Can we use any third Party Application to convert
Read More »
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 setup. Before we start the configuration please make sure that
Read More »
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 make a connection to the server. Connections through a server
Read More »
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 from a full backup, repair it, or rebuild it. The
Read More »
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 database servers or for web services where website data is
Read More »
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 make it so simple that MSSQL can be installed using
Read More »
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 Server >> Replication (right Click) >> Publisher Properties >> Publication
Read More »
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 setup I have found that some tables were not replication.
Read More »
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 replication over Internet and also I will tell how to
Read More »