MySQL to SQL Server Data Migration Through SSIS

MySQL to SQL Server Data Migration Through SSIS In this post we will learn MySQL to SQL Server Data Migration Through SSIS. Here we are using SQL Server integration Services for data migration. SSIS will help us scheduling it as job to run this package on time to time. For this first we have to add

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Hi Friends, recently i am working with MySQL, i have to set up DSN(data source name) to  access MySQL from Microsoft SQL Server.But ended up with following error: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture

Create Database, Table in MySQL

Create Database, Table in MySQL In this tutorial we will learn Create Database, Table in MySQL, also we will learn how to insert, Update, Delete data into MySQL table. MySQL has almost same syntax as SQL Server. In earlier post we had learnt How to Install MySQL in Windows 7. Script: Create schema dummy; use dummy; CREATE

How to Install MySQL in Windows 7

How to Install MySQL in Windows 7 In this tutorial we will explain How to Install MySQL in Windows 7. You can download MYSQL installer from here. MySQL: MySQL is the world’s second most widely used open source relational database management system. It is named after co-founder Michael Widenius’s daughter, My.The SQL phrase stands for Structured Query

How to Password Protected Backup In SQL Server

How to Password Protected Backup In SQL Server In this post we will learn How to Password Protected Backup In SQL Server. Password Protected backup in SQL Server gives you an additional security, to password protect SQL Server files we will use MEDIA PASSWORD. Setting backup media password are important and useful for securing misuse of data.

How To Delete Backup Files Older Than n Days

How To Delete Backup Files Older Than n Days In this post we will learn How To Delete Backup Files Older Than n Days. This will help us in deleting old file to free space from disk, we can do it manually. But by this approach we can delete files by setting number of days to