How hard could that be?
MS SQL in Action
First, I needed to do a complete DDL on TableOne and replace every instance of the word "TableOne" with "TableTwo". It works, even though it is bulky and takes time, especially when the DDL was 68 lines long.
The second step was not too bad.
SELECT * FROM TableOne INTO TableTwoOk - that did not seem too hard, until you see how this can be accomplished in MySql.
CREATE TABLE table_1 LIKE table_2;Which looks easier to you?
INSERT INTO table_1 SELECT * FROM table_2;
Here's another wrinkle: what about table-level permissions? Which side is easier to manage?
Until next time,