Author Topic: Migrating non-sales data from SQL CE to SQL Server Express  (Read 10522 times)

DQ

  • Jr. Member
  • **
  • Posts: 82
Migrating non-sales data from SQL CE to SQL Server Express
« on: January 27, 2013, 12:49:40 pm »
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

  • Jr. Member
  • **
  • Posts: 96
Re: Migrating non-sales data from SQL CE to SQL Server Express
« Reply #1 on: January 27, 2013, 02:40:14 pm »
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

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564

DQ

  • Jr. Member
  • **
  • Posts: 82
Re: Migrating non-sales data from SQL CE to SQL Server Express
« Reply #3 on: January 27, 2013, 06:14:33 pm »
Thanks @rvandam and @emre.