Convert MySQL dump into SQL Server code.

  • Hello! I really need to create a SQL Server database, a real simple one, and I can really use some help converting from MySQL to SQL Server.

    If anyone has the know-how, I will GLADLY make a PayPal donation, and it would REALLY help me out a lot! 🙂

    Here is the MySQL dump:

    CREATE TABLE IF NOT EXISTS `categories` (

    `cid` int(11) NOT NULL AUTO_INCREMENT,

    `cat_name` varchar(255) NOT NULL,

    `cat_url` text NOT NULL,

    PRIMARY KEY (`cid`)

    );

    INSERT INTO `categories` (`cid`, `cat_name`, `cat_url`) VALUES

    (1, 'Action Figures', 'http://www.marioplanet.com/action_figures/'),

    (2, 'Board Games', 'http://www.marioplanet.com/board_games/'),

    (3, 'Keychains', 'http://www.marioplanet.com/keychains/'),

    (4, 'Miscellaneous', 'http://www.marioplanet.com/miscellaneous/'),

    (5, 'Plush Toys', 'http://www.marioplanet.com/plush_toys/'),

    (6, 'Super Balls', 'http://www.marioplanet.com/super_balls/'),

    CREATE TABLE IF NOT EXISTS `search` (

    `id` int(11) NOT NULL AUTO_INCREMENT,

    `cat_id` int(11) NOT NULL,

    `name` varchar(255) NOT NULL,

    `img` varchar(255) NOT NULL,

    `desc` text NOT NULL,

    `url` text NOT NULL,

    PRIMARY KEY (`id`)

    );

    INSERT INTO `search` (`id`, `cat_id`, `name`, `img`, `desc`, `url`) VALUES

    (1, 5, 'Mario (Running) - Plush', 'janko_javonovic_chat.png', 'This plush rendition of Super Mario showcases Mario doing one of his most used actions: RUNNING! Mario is always running over and under koopas, goombas and other Bowser baddies. Now you too can have Super Mario running with this plush toy!', 'http://www.marioplanet.com/plush/chatting_on_warp_speed_with_janko_javonovic.html') ,

    (2, 5, 'Yoshi (Green) - Plush', 'march_09.png', 'Yoshi has been Mario’s trusted steed for dozens of video games and now he is coming to the world of plush! This Yoshi comes in Yoshi’s standard and lovable color: green. Yoshi’s detail shines in the big snout and brown and yellow shoes, making this plush toy one of the most realistic available!', 'http://www.marioplanet.com/plush/imagedump_march_2009.html'),

    (3, 5, 'Mushroom - Plush', 'polaroid_css3_jquery.png', 'The classic power up of the Mushroom Kingdom and the Super Mario Bros. series is now available for play, display, and cuddling with this plush toy! The adorable Super Mushroom has appeared in hundreds of video games and now in thousands of rooms around the world!', 'http://www.marioplanet.com/plush/creating_a_polaroid_photo_viewer_with_css3_and_jqu ery.html'),

    (4, 5, 'Princess Peach - Plush', 'photoshop_icons.png', 'The princess of the Mushroom Kingdom, Princess Peach, is here in soft plush form! Princess Peach has been the “Damsel In Distress” for the Super Mario Bros. series for many generations and has finally come to the plush world. Authentic representation of the princess shows in the bright colors and extreme detail, making a fantastic addition to any collector or Princess Peach fan!', 'http://www.marioplanet.com/plush/a_walkthrough_on_creating_icons_with_photoshop.htm l'),

    (5, 5, 'Question Mark Block (With Sound) - Plush', 'iphone_contactsapp.png', 'The most famous block in video game history… EVER!! Now you can save the Mushroom Kingdom like Mario with this Question Block plush toy equipped with sound. All that is required to activate the famous sound is a little punch from below the block JUST LIKE MARIO! ', 'http://www.marioplanet.com/plush/the_iphone_contacts_app_with_css_and_jquery.html') ,

    (6, 5, 'Bowser - Plush', 'band_websites.png', 'Super Mario’s biggest enemy: BOWSER!! This ferocious villain is now in soft and squeezable plush form (but still just as villainous of course). Vivid colors showcase this monstrosity and bring him to life. Sharp spikes (although in plush form), protrude from his shell in various directions for a realistic look.', 'http://www.marioplanet.com/plush/gimme_some_inspiring_band_website_designs.html'),

    (7, 1, 'Fire Mario - Figure', 'marcofolio_2.0.png', 'This small Fire Mario figure represents Mario after he collects one of the most recognizable power ups: A fire flower! In the video games, Fire Mario has the ability to shoot fire balls at his enemies. The way to distinguish Fire Mario from regular Mario is by Fire Mario’s white and red outfit vs regular Mario’s blue and red outfit.', 'http://www.marioplanet.com/action_figures/marioplanet.com_gets_a_facelift.html'),

    (8, 1, 'Mario, Luigi and Star - Figure Set', 'programming_quotes.png', 'This figure set brings together two of the most important characters and one of the most important items from the Super Mario Bros. series in ONE SET! Super Mario and Luigi are the two brothers and the two heroes of the Mushroom Kingdom. The Power Star tends to be one of their items of choice because it allows them to temporarily turn invincible being able to easily take out some of the fiercest enemies in the Mushroom Kingdom.', 'http://www.marioplanet.com/action_figures/27_inspiring_top_notch_programming_quotes.html'),

    (9, 1, 'Toad - Figure', 'february_09.png', 'Toad is one of the biggest recurring characters in the Mushroom Kingdom as he appears in almost every video game. This vinyl Toad figure is one of a kind and can be used in a variety of ways. Many action figure enthusiasts prefer to leave them in the box where others like to collect them all and play with them. YOU choose and get the Toad figure today!', 'http://www.marioplanet.com/action_figures/imagedump_february_2009.html'),

    (10, 2, 'Nintendo Monopoly', 'groovy_grails_soa.png', 'The greatest characters in all of video game history are bringing you Nintendo Monopoly. Characters replace properties in this board game and you can buy Mario, Luigi, Link, Star Fox, Kirby and many more! 6 collectible playing tokens include: Koopa Shell, Mario Hat, DK Barrel, NES Controller, the shield of Link, and the boots of Link. "? Block" and "Coin Block" cards replace “Chance” and “Community Chest” cards. Special Nintendo themed money is also included. Order Nintendo Monopoly and start monopolizing your favorite video game characters today!', 'http://www.marioplanet.com/board_games/getting_groovy_in_an_soa.html'),

    (11, 6, '1-UP - Super Ball', 'iphone_springboard.png', 'This 1-UP Super Ball is a MUST HAVE for Super Mario Bros. and super ball enthusiasts. This super ball has a 1-UP embedded in the middle for some Mario flare. High quality material allows a great bounce on almost any surface! All you need is this ball and a wall (sold separately) and you will have fun for hours!', 'http://www.marioplanet.com/super_balls/the_iphone_springboard_in_xhtml_css_and_jquery.htm l'),

    (12, 6, 'Fire Flower - Super Ball', 'poststamps.png', 'This Fire Flower Super Ball is a MUST HAVE for Super Mario Bros. and super ball enthusiasts. This super ball has a Fire Flower embedded in the middle for some Mario flare. High quality material allows a great bounce on almost any surface! All you need is this ball and a wall (sold separately) and you will have fun for hours!', 'http://www.marioplanet.com/super_balls/social_post_stamps_free_icon_set.html'),

    (13, 6, 'Power Star - Super Ball', 'aled_lewis.png', 'This Power Star Super Ball is a MUST HAVE for Super Mario Bros. and super ball enthusiasts. This super ball has a Power Star embedded in the middle for some Mario flare. High quality material allows a great bounce on almost any surface! All you need is this ball and a wall (sold separately) and you will have fun for hours!', 'http://www.marioplanet.com/super_balls/spotlight_t-shirt_design_from_aled_lewis.html'),

    (14, 3, 'Boo - Keychain', 'akismet_joomla.png', 'Some may think of this as an ordinary keychain. But only we know. The truth.. That it’s actually haunted… BY BOO!! Boo the ghost has appeared in Super Mario Bros. video games since the originals and now you can always have him by your side with this collectible Boo keychain. The keychain can be attached where any normal keychain can be: ANYWHERE!', 'http://www.marioplanet.com/keychains/enable_akismet_support_in_joomlacomment.html'),

    (15, 4, 'Super Mushroom - Carrying Pouch', 'iphone_unlock.png', 'Ever wish you had a practical, stylish, portable, Mario themed carrying pouch? WAIT! Did you just say MARIO THEMED!! Now, you can have this Super Mushroom carrying pouch to represent your Mario love while carrying you everyday items such as keys, cash, notes, etc. OR, more video game related items such as Nintendo DS cartridges, ear buds, trading cards, etc.', 'http://www.marioplanet.com/miscellaneous/the_iphone_unlock_screen_in_xhtml_css_and_jquery.h tml'),

    (16, 4, 'NES Controller - Megaphone', 'speech_balloons_css3.png', 'This megaphone takes a retro remake in light of the NES controller! To speak into the megaphone, slide the on/off switch located on the back of the megaphone to the on position. Then, press the ‘A’ button on the megaphone and speak into the megaphone for the amplification to take place. There is a volume slider control on the front of the megaphone as well.', 'http://www.marioplanet.com/miscellaneous/styling_a_chat_conversation_with_text_balloons.htm l'),

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply