SambaPOS Forum

English Boards => Support => Topic started by: lernoutmaltas on May 28, 2013, 10:50:13 am

Title: Please how to get a copy of the database from sql server 2008 and Save As .sdf?
Post by: lernoutmaltas on May 28, 2013, 10:50:13 am

For example it may be that my server a problem, how do I save a copy of it from the Management Studio and save the format .sdf?

Title: Re: Please how to get a copy of the database from sql server 2008 and Save As .sdf?
Post by: lemmings on May 28, 2013, 04:31:10 pm

Do you want to export your SQL server database to the SQL compact edition ?

I dont know a way it can be done in SQL Management Studio without writing your own script.  There are a few third party tools that can accomplish this.

If you just want a backup of the SQL server this can be done in SQL Management studio, right-click on database in left hand pane and select tasks -> backup.

Title: Re: Please how to get a copy of the database from sql server 2008 and Save As .sdf?
Post by: lernoutmaltas on May 29, 2013, 06:22:54 am

Thanks for answering lemmings, I would not need a backup, but a copy of the server and format .sdf to the following situation, if the server is a problem I will have to use the system with the local database, tried all forms but I can not, I thought this would be a standard feature in Management Studio but it does not have to export as sdf and could not find any other way, I hope you understand because my English is not very good.

Title: Re: Please how to get a copy of the database from sql server 2008 and Save As .sdf?
Post by: emre on May 29, 2013, 07:27:15 am

I think you'll find the answer under this topic
http://forum2.sambapos.org/index.php/topic,184.0.html (http://forum2.sambapos.org/index.php/topic,184.0.html)