Re: MS SQL to MySQL 5 migration performance
Posted by: banglore agent1
Date: September 13, 2009 08:29AM

In Sql Server you can link to an external odbc datasource. You could then do a the following



Insert Into si_acl_groups ("group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting")

select "group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting"

from [linkeddb].database.tablename



This will allow your entire table to be inserted without using unions.



Another way is to use the bulk copy program (BCP) or DTS for imports, both of which use flat files to pull information into tables. (note: the aformentioned methods also do extracts.)

Enjoy

-----------------------------------------
Marco Island Florida waterfront vacation rental house
steroid



Edited 2 time(s). Last edit at 09/25/2009 09:40AM by banglore agent1.

Options: ReplyQuote


Subject
Written By
Posted
Re: MS SQL to MySQL 5 migration performance
September 13, 2009 08:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.