Click here to Skip to main content
15,889,216 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to kept data of SQL SERVER as a backup from live db to local system. i take script every month and create new db & enter all data in new db through script.
I want to kept data in one db not in multiple (that i create every month). How is this possible that i could not create new db every month and all data update in existing db

What I have tried:

is it possible that database data update in same db every time for example i take script of month January and make a db with name "testing" & when i take script of February and how i enter data in the same db "testing" that previous data present and new data also entered
Posted
Updated 12-Apr-18 6:49am

1 solution

You could use SELECT INTO to copy your tables, see: INSERT INTO new SQL table with SELECT INTO[^]
But be warned this does not create constraints, indexes, defaults etc.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900