Global Database Posted by stegess on Wed 06 of Aug, 2008 12:57 GMT Can you provide the global database as a SQL Server database (SQL server 2000/2005 format), or is MDB the only option?
Posted by Phil on Wed 06 of Aug, 2008 16:43 GMT It is possible to set it up on an SQL server database. I have done this on one occasion and I think that I used the Data Transformation Services (DTS) under SQL server to import the tables from the MDB file. I will try to do this again, and then export the schema as an SQL-script. If I recall correctly, it was important to choose an appropriate string type for the translations. I probably chose nvarchar, but I have no idea what length I specified. I will check this out, but I don't expect to have time for it in the next two days. Phil
Posted by Phil on Sat 09 of Aug, 2008 12:52 GMT Hi, I have tried out transferring the global database to SQL server using the Data Transformation Services (DTS) and it worked very well. I would recommend using this method. I have written a separate article about how to do this, showing screenshots of each step. You can access this article via the Articles menu, or with the link in the last sentence. If you would prefer to generate a database using SQL scripts, let me know and I can generate these scripts. By the way, DTS automatically select the datatype nvarchar(max) for the translations, which is OK by me. I don't know if SQL Server would be significantly more efficient if we specified a shorter length, but I doubt it. Phil