MySQL -> ms-sqlserver

Hi,
I have to convert an MySQL database into a ms-sqlserver database.
Anyone know a software (is is possible freeware or not so expensive) to
translate database?
I have only to translate tables, no triggers or stored procedures.
Or anyone can send me a link to a web site about this problem?
Tank you and escuse for my terrible english!

Simone (form Italy)Hi there,

I don't think you need to shell out for a seperate tool to do this. You
can use built in SQL Server tools but it might take more time.

One possible option for you is, in SQL Server, create a linked server
to your MySQL database. You'll probably use an ODBC provider but I'm
not sure of the specifics in that regard.

You can create a linked server via the GUI or using T-SQL but it's
generally easier through the GUI. There's a good write-up about it in
SQL Server Books Online so I would refer you to there first. However,
if you're not sure how to add the linked server just give us a buzz and
we'll see if together we can make it work.

For the purposes of transferring data, in your linked server definition
you might want to specify that you will connect to your MySQL database
as a user with admin rights.

After you've defined a linked server you can access the MySQL tables in
a query (once again, techniques for accessing linked servers can be
found in SQL Server Books Online). If your tables are already created
on SQL Server then do:

INSERT INTO <SQL Server Table>
SELECT * FROM <MySQL Table
If your tables aren't yet created on SQL Server you could do:

SELECT * INTO <SQL Server Table Name>
FROM <MySQL Table
Hope that helps a bit but sorry if it doesn't|||Ciao Simone,
se fai un Dump, io ho un programma per ricaricarlo in SQL server.
Fammi sapere...

-tom
Simone ha scritto:

> Hi,
> I have to convert an MySQL database into a ms-sqlserver database.
> Anyone know a software (is is possible freeware or not so expensive) to
> translate database?
> I have only to translate tables, no triggers or stored procedures.
> Or anyone can send me a link to a web site about this problem?
> Tank you and escuse for my terrible english!
> Simone (form Italy)|||Hi!

You could also use Oracle Migration Workbench (Migration Workbench).
Workbench can be downloaded from the technet website for free.
http://technet.oracle.com/tech/migr...ch/content.html.
o Migrate multiple MS SQL Server 6.5, MS SQL Server 7.0, MS SQL Server
2000,
MySQL3.22 and 3.23 Sybase Adaptive Server 11 and 12 databases to a single
Oracle database.

Cheers ;)
Jack

"Simone" <sp1213@.katamail.com> wrote in message
news:e4sodl$1n4v$1@.newsreader1.mclink.it...
> Hi,
> I have to convert an MySQL database into a ms-sqlserver database.
> Anyone know a software (is is possible freeware or not so expensive) to
> translate database?
> I have only to translate tables, no triggers or stored procedures.
> Or anyone can send me a link to a web site about this problem?
> Tank you and escuse for my terrible english!
> Simone (form Italy)

My SSIS Presentation.

I was demonstrating some of SSIS's capabilities to our Software Development Manager and VP of IS. (We are deciding which ETL tool to use for our DW project. So goes this project goes the house).They liked what they saw and were crazy over Fuzzy lookup but commented that SSIS seems very much oriented toward the programmer side of the house. It was, maybe, not the best tool for the Business analysts who are working closely with us on this project.

Any comments on their comment?

I wonder if SSIS "data source views" (which I haven't looked at at all) address their concerns?

Barkingdog

SSIS is a programmer/developer tool. All ETL tools are programmer/developer tools.

Exactly what do they want for the business analysts? SSIS is a platform for providing the data that business analysts may use - it is NOT something to be used by business analysts themselves.

-Jamie

|||

I know the Analysts are looking for a design tool they can use to create a Logical model of the warehouse. Later on the developers will convert the logical into a physical model. Since the analysts have a great understanding of the business implications of our data they will also be the ones completing the "Description" field of each field in the Data dictionary. I guess the company is looking for one product that can do all of this. (logical modeling, data dicitonary, let analysts get involved in the process, satisfy developer needs. They seem to think that the Sunopsis product I mentioned has better coverage of all these areas.)

Barkingdog

|||

I see. I've never seen Sunopsis but would be surprised if it has a logical data modelling tool. But hey, that's good to know.

Personally I use ERWin for this sort of stuff. I like the seperation of data modelling from implementation. To me, design and implementation are different disciplines and should be treated as such. That's just my opinion of course.

In response to your earlier question DSVs are not, in my opinion, a tool for data modelling. DSVs are something you build AFTER the physical model has been implemented. And before you have the physical model you have to build the logical model.

-Jamie

|||

It's worth noting that SQL Server does have exactly the capabilities you are seeking, barking - perhaps not quite in the way you have currently thought.

Analysis Services is the market leading tool for OLAP - which is, of course, a high performance architecture for delivering business analytics to end users.

In Analysis Services it is possible to build a cube - an analytic model - in a logical mode, then generate the physical model from that. These are called top-down cubes.

See: http://msdn2.microsoft.com/en-us/library/ms174482.aspx and http://msdn2.microsoft.com/en-us/library/ms174883.aspx

hth

Donald