English Boards > Support

.sdf file convert to SQL 2005 database

<< < (2/2)

Anesthetic:
Mozhi,

to transfer from sql server to sql server, you just need to create a backup of the database from one, then on your new sql server create the database SambaData2 and restore the file you just backed up earlier on it

As for table modifications, open up the database by clicking the + sign next to the database name, search for Tables and click + sign next to it, you'll notice all the tables being listed there. To modify them, right click on any table and search for the option to open up the table.

Instance name doesn't affect the backup files when you restore them, so no additional changes or settings are needed.

Hope I helped,
Anesthetic.

Navigation

[0] Message Index

[*] Previous page