Showing posts with label thnx. Show all posts
Showing posts with label thnx. Show all posts

Monday, February 13, 2012

Copy SQL server 2000 database structure

Hello,

Is there some solution to copy database using VB.NET 2003 code with all constraints ,specifications and relationships ?

Thnx in adv

you may script the database store it in a file. then use the "shell" command to run sqlcmd using the script you generated

or you may wan't to progaram using the sql SMO.