This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JForum and the fly likes Adapting SQL Files for MS SQL Server 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Adapting SQL Files for MS SQL Server 2005" Watch "Adapting SQL Files for MS SQL Server 2005" New topic
Author

Adapting SQL Files for MS SQL Server 2005

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I'm currently working through the process of installing jForum on MS SQL Server 2005 and I ran into some issues when executing the original sqlserver_db_struct.sql file. Here are the things I had to change to get past the errors. The location of this file is within the jforum-2.1.8\WEB-INF\config\database\sqlserver directory.

In short, the only errors I was getting were within the CREATE TABLE function for jforum_moderation_log. See the changes below.

Removed, Added

CREATE TABLE CREATE TABLE [dbo].[jforum_moderation_log] (
[log_id] [bigint] IDENTITY(1,1) NOT NULL,
[user_id] [bigint]) NOT NULL,
[log_description] BLOB[varbinary](max) NOT NULL,
[log_original_message] BLOB[varbinary](max),
[log_date] DATE[datetime] NOT NULL,
[log_type] [tinyint] DEFAULT ((0)),
[post_id] [bigint],
[topic_id] [bigint],
[post_user_Id] [bigint]
PRIMARY KEY CLUSTERED
(
[log_id] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

Once I corrected these items, both the sqlserver_db_struct.sql file and the sqlserver_db_dump.sql file executed without errors and the data appears to have populated correctly.

Now for the real adventure. Working to get the jForum instance running on Ubuntu 8.10. It looks like we're going to have to do a manual install for SQL or intall for mySQL with the UI and then convert afterwards. Any guidance here would be greatly appreciated.

Where does the sqlserver.sql file come into play? How about the sqlserver.properties file?
[originally posted on jforum.net by cgabriel]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Adapting SQL Files for MS SQL Server 2005
 
Similar Threads
Mysql Date problems
SQL Server support and migrating from HSQLDB to MS SQL
combining LEFT OUTER JOIN and WHERE
Getting JForum to run with MS SQL
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9