Re: Memory Problem with 1 DB. Other DB ok

[Gabriel Dunn]

This is the create statement generated from the MySQL Wordpress table. I am only trying to select the ID column into MSSQL, not the entire table. Then I compare the IDs that I imported, against a MSSQL table. That step is all MSSQL and not a problem.

Any ID not in the uploaded table would be written back to the MySQL database with an insert statment.

CREATE TABLE `wp_users` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`),
KEY `ID_Desc` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2904656 DEFAULT CHARSET=utf8;


Example INSERT to MySQL from MSSQL:

INSERT INTO web_prod.wp_users ( ID ,user_login ,user_pass ,user_nicename ,user_email ,user_url ,user_registered ,user_activation_key ,user_status ,display_name) VALUES ( 2904729 ,'member1' ,'' ,'Jon' ,'[e-mail]' ,' ' ,'2015-01-28 15:17:35' ,' ' ,'2' ,'Jon Smith');