Copy data from Hypersonic to Sql server 2008

I created a website using liferay with some sample pages. Later we wanted to import some 23000 users into liferay. The data is in csv format.

I dont know java. tried to insert data using C#.net and liferay webservices. No luck. So i changed the settings to point to Sql Server.

Now all the data I created for the sample site is residing in the Hypersonic DB.

开发者_高级运维Is there any way to copy the data to sql server?

---

The simplest way would be to gather all your table data from HSQLDB into .CSV format.

If you can use your original .csv file, that's great. If needed, you'll need to find a way to get your data from HSQLDB into a text file. You may have a tool already that you know of. Perhaps you could use RazorSQL's Export Tool. (screenshot).

Then you can import .csv to SQL Server using the SQL Server Management Studio Import Wizard. The screenshots are a bit out of date, but you'll have no trouble figuring it out.