Click here to Skip to main content
15,617,203 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, is there a way to copy one database to another one without knowing its content (table names, rows etc)? I'm thinking of using INFORMATION_SCHEMA meta-datas and SqlBulkCopy but they seem to be insufficient. Any pointers? Thanks in advance.
Thomas Nielsen - getCore 19-Aug-14 2:34am    
does the data have to land in a database containing other data or simply the move to another server?
YourAverageCoder 19-Aug-14 2:38am    
It's gonna be moved from some remote server to my local server.
Mehdi Gholam 19-Aug-14 2:35am    
Try backup/restore.
Vinay Mistry 19-Aug-14 3:19am    
Yes backup-restore is the good way to copy database from remote server.

1 solution

The normal way of doing this is backup/restore. If you are going to move the schema only you are going to need to walk the dependency structure as you will need to cater for foreign keys and create the appropriate tables and views first.

We use Red-Gate suite of tools for this type of operation but they are not free!
Share this answer

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