Post reply

WOSYST database to a SQLserver db

  • October 26, 2012 at 9:23 am

    #270203

    Does any one know how to convert a wosyst database (St. Croix Systems) to a sql server.

    I have tried to import this wosyst.db to sql server 2008R2 I did not work.

    I was told by my friend that SQL serve can not import this, It needs a third party software in order to achieve it.

    I think this db was created using a MYSQL (not 100% sure just a guess work basing on online search)

    Placed an screen shots of the error in SQL server and the properties of the file that show up.

    Thanks for you time and guidance.

  • October 26, 2012 at 9:33 am

    #1553257

    I think your best bet would be to use a conversion tool like http://blogs.msdn.com/b/ssma/archive/2011/04/29/converting-from-mysql-to-sql-server-working-with-data-types.aspx ... That is where I would start

  • October 26, 2012 at 9:33 am

    #1553258

    just the raw MYSQL database file all by itself, no.

    you need a mysql instance running so you can connect to the database.

    you might need to install MYSQL and attach that database to it before you can go forward.

    After that is done, then you can use SSIS or even a linked server to connect and extract/insert/update/delete to and from the MYSQL database.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 26, 2012 at 1:24 pm

    #1553365

    After you get MySQL up and running you can also look at using SSMA for MySQL to assist in the migration.

    Joie Andrew
    "Since 1982"

Viewing 4 posts - 1 through 3 (of 3 total)

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