Question

firsttime deployment to SQL Server database

1

I have a project with an internal database; now I deployed that to an SQL Server Database. This works ok but the data which were already in the internal database are not moved to the SQL Server database. So the SQL server database contains contains all the tables but these are empty. Is it possible to copy the data to the SQL database / How do I do that

asked 2011-02-25

Paul van Eulem

2 answers

Sebastiaan van den Broek · Answer 1 · 2011-02-25

There is no default mechanic for moving your data between databases, it's up to the end-user to migrate the data. This is usually possible between different database types though the built-in database (hsqldb) is usually just used for quick testing and as such does not provide a whole lot of options for migrating data, though I'm sure it's possible.

Fedor Klinkenberg · Answer 2 · 2011-02-25

Perhaps you can use the 'MySQL Migration Toolkit'.