title: converting mysql database to sql server
body: <p>i have a mysql database:</p>
  
  <pre><code>/*
  MySQL Data Transfer
  Source Host: 10.0.0.5
  Source Database: jnetdata
  Target Host: 10.0.0.5
  Target Database: jnetdata
  Date: 5/26/2009 12:27:33 PM
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  -- ----------------------------
  -- Table structure for chavrusas
  -- ----------------------------
  CREATE TABLE `chavrusas` (
    `id` int(11) NOT NULL auto_increment,
    `date_created` datetime default NULL,
    `luser_id` int(11) default NULL,
    `ruser_id` int(11) default NULL,
    `luser_type` varchar(50) default NULL,
    `ruser_type` varchar(50) default NULL,
    `SessionDay` varchar(250) default NULL,
    `SessionTime` datetime default NULL,
    `WeeklyReminder` tinyint(1) NOT NULL default '0',
    `reminder_phone` tinyint(1) NOT NULL default '0',
    `calling_card` varchar(50) default NULL,
    `active` tinyint(1) NOT NULL default '0',
    `notes` mediumtext,
    `ended` tinyint(1) NOT NULL default '0',
    `end_date` datetime default NULL,
    `initiated_by_student` tinyint(1) NOT NULL default '0',
    `initiated_by_volunteer` tinyint(1) NOT NULL default '0',
    `student_general_reason` varchar(50) default NULL,
    `volunteer_general_reason` varchar(50) default NULL,
    `student_reason` varchar(250) default NULL,
    `volunteer_reason` varchar(250) default NULL,
    `student_nli` tinyint(1) NOT NULL default '0',
    `volunteer_nli` tinyint(1) NOT NULL default '0',
    `jnet_initiated` tinyint(1) default '0',
    `belongs_to` varchar(50) default NULL,
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5913 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Table structure for tbluseravailability
  -- ----------------------------
  CREATE TABLE `tbluseravailability` (
    `availability_id` int(11) NOT NULL auto_increment,
    `user_id` int(11) NOT NULL,
    `weekday_id` int(11) NOT NULL,
    `timeslot_id` int(11) NOT NULL,
    PRIMARY KEY  (`availability_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=10865 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Table structure for tblusers
  -- ----------------------------
  CREATE TABLE `tblusers` (
    `id` int(11) NOT NULL auto_increment,
    `password` varchar(50) default NULL,
    `title` varchar(255) default NULL,
    `first` varchar(255) default NULL,
    `last` varchar(255) default NULL,
    `gender` varchar(255) default NULL,
    `address` varchar(255) default NULL,
    `address_2` varchar(255) default NULL,
    `city` varchar(255) default NULL,
    `state` varchar(255) default NULL,
    `postcode` varchar(255) default NULL,
    `country` varchar(255) default NULL,
    `email` varchar(255) default NULL,
    `emailnotes` varchar(255) default NULL,
    `Home_Phone` varchar(255) default NULL,
    `Office_Phone` varchar(255) default NULL,
    `Cell_Phone` varchar(255) default NULL,
    `Contact_Preference` varchar(255) default NULL,
    `Birthdate` datetime default NULL,
    `Age` varchar(255
  </code></pre>
  
  <p>and it goes on for about 10mb</p>
  
  <p>i need to convert it to ms sql, how do i do it?</p>