Way we save our data in SQL server?

Question

Way we save our data in SQL server?

Answer 1

You store data in SQL server databases by designing an RDBMS (relational database management system.) Records are added, modified, and deleted by executing SQL statements which are usually invoked by a GUI enabled front-end.

Answer 2

It depends on which database system you are using. PC databases Access, FileMaker, etc... usually just require a backup to CD and restore to the same directory location on the new system or a copy over the network of that filesystem. Typically the database software must be installed there also to make sure all the proper DLLs and registry entries are there for runtime execution. On larger UNIX databases like Oracle and DB2 a lot more configuration is usually required to recreate their environment on the target box. Also licensing issues may require repurchasing the database software in the CPUs on the new machine exceeds the number on the original machine.

Answer 3

you create tables structures and using SQL queries you store and retrieve data.



Hope this helps.