thenrich
asked on
Copy database
What would be the easiest way to copy a database from a SQL database to a SQL express databse on my local machine?
ASKER
What does that mean to 'backup'? I don't need the whole server only 1 database in the server. The data wold be groing from sql2k to sql express. I think it just might be easist to write a .NET app to do it. I can manage 2 connections and do what I need. I was just wondering if there was some standard protacol I was missing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. backup at A and restore at B
2. generate the scipt of the database using (database publishing wizard) and execute the same at destination
3. replication