Our company is migrating to Java platform. As part of that migration we also are moving our DB from MS SQL Server 2005 to MySQL.
Developers requested our existing SQL Server database schema and sample data so they can develop and test data migration script.
I generated a CREATE TABLE script for every table using "Generate Scripts" tool in MS SQL Server Management Studio. But can't figure out how to generate INSERTs (the TOP 3 rows) INTO those tables.
Is there a way to generate a script that will have CREATE TABLE statements followed by INSERT INTO statements that will insert TOP 3 rows from existing table?
Let's say there is a table tblUsers that has 1000 rows of data. I would like to generate a script that will have:
CREATE TABLE tblUsers(ID INT, UserName VARCHAR(50))
INSERT INTO tblUsers(1, 'Jill')
INSERT INTO tblUsers(2, 'John')
INSERT INTO tblUsers(3, 'Jack')
Where [1,Jill],[2,John] and [3,Jack] are real (TOP 3) rows from tblUsers.
Other ideas on how to get around that are welcome.