SDF files

By using SQL Server Management Studio, you can edit .SDF files for Retail TallyMan inventories.

1. Copy the .SDF file to your local drive.

2. Navigate to File > Connect Object Explorer and select your file

3. Change Server type: to SQL Server Compact Edition.

4. You can find and update using a script similar to the following:

Note: The following is used to fix a problem where the inventory amount entered is greater than five characters and TallyMan is crashing.

;Finding items

select * from tallying

where department='WCGIFTS'

and category='WCMEDIA'

and item='WC4X6PSTCR'

update tallying

set quantity=1

where quantity=11208

and department='WCGIFTS'

and category='WCMEDIA'

and item='WC4X6PSTCR'