Hey guys,
Due to a number of recent cases exceeding Access's 2GB limit I have taken the plunge and am migrating our case database to Ms SQL.
Does anyone have the SQL statement to create the case table on MS SQL before I go butchering it from the Access default db.
Thanks
Ian
Don't you get it with the Program Files for C4P Review?
Program Files\C4P3.0\C4P Review\SQL Database.sql?
I'm sure that's what I used and I'm madly trying to find my instructions to confirm.
Edit or have I completely misread your post (I think I have it says case!!)
Hi John,
Yeah there is a statement to create the hash db on Ms and mySQL but not one for the case db.
cheers
Could you use the native upsizing wizard in Access to migrate it to a SQL db? Upsizing would preserve the database structure, including data, (I think indexes), and default settings. It automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents and maintains table relationships and referential integrity after you upsize. If it doesn't do the indexes you could rebuild them with the database diagram tool in Visual Studio.