Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lovehui
Yak Posting Veteran
60 Posts |
 Posted - 2009-03-20 : 15:50:14
|
| Hello, May I only back up tables instead of entire database backup?The reason is I want to copy a database from another machine, but I want to keep my stored procedures unchanged.If I copy the whole database then my stored procedures and all functions will be overwriten.Thanks |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-03-21 : 04:56:37
|
quote:
Originally posted by lovehui
Hello, May I only back up tables instead of entire database backup?The reason is I want to copy a database from another machine, but I want to keep my stored procedures unchanged.If I copy the whole database then my stored procedures and all functions will be overwriten.Thanks
export the tables to different database.->create a test database->right click on database from which tables are to be exported.->select tasks->export->follow the instruction.Regards,Ahmad Osama |
 |
|
|
lovehui
Yak Posting Veteran
60 Posts |
Posted - 2009-03-22 : 22:14:38
|
| Suppose I have an exsting database "aaa", I want to delete all tables and views in "aaa" and copyall tables and views in database "bbb".During the process, all stored procedure and functions in "aaa" are unchanged.Can you elborate the process? |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-03-25 : 06:05:19
|
| Why don't u like to create a script for your views,sp and functions and apply this script after importing your database. |
|
|
|
|
|
|
Back up tables