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.)


Marco Island Florida waterfront vacation rental house

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

Options: ReplyQuote

Written By
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.