Migrating non-sales data from SQL CE to SQL Server Express

[DQ]

Hello,
  I am able to migrate my SQL CE data to SQL Server Express but the problem is I had many trial/training transaction which I want to delete.
 
   I want to migrate non-sales data only (configuration/rules/action/printer/emp ) or delete sales data from the database.

   I am using SambaPOS 2.99c release.


Thanks,

[rvandam]

I saw a script for that on this forum coming by....

You can also use Microsoft Management Studio for this.

Be sure to close all tables, and close working period. Then you can delete tickets and sales data (edit rop200 rows). But before doing that, use management studio to make a full backup of your database.

[emre]

This may help
http://forum2.sambapos.org/index.php/topic,60.0.html

[DQ]

Thanks @rvandam and @emre.