如何使用C#在sql Server 2005中使用旧数据库创建新数据库? [英] How to create new database using a old one in sql server 2005 from C#?

问题描述

我如何创建新数据库并制作新日志和mdf文件，以从旧数据库中复制一些数据，我必须从C#中执行此操作，还必须从我选择的文件夹中复制一些dotnet exe.

请帮助我.

hi there,

How i can create a new database and make new log and mdf files copying some data from old one and i have to do this from C# and also copy some dotnet exe from the folder of my choice.

please help me.

推荐答案

如果您需要从旧数据库中获取数据并使用该数据库创建新数据库，则可能是两种最简单的方法:
-进行备份 [还原 [ ^ ]作为新数据库
-分离数据库，将其复制并将其附加到其他位置.请参阅:分离和附加数据库 [

If you need to get the data from an old database and using that create a new one, two perhaps easiest ways are:
- Take a BACKUP[^] and then RESTORE[^] it as a new database
- Detach the database, copy it and attach it to somewhere else. See: Detaching and Attaching Databases[^]

Google是您的朋友:祝您访问愉快他经常.与在这里发布问题相比，他可以更快地回答问题.

使用您的主题作为搜索词的快速搜索 将这三个作为顶部链接:

使用C#创建SQL Server数据库 [以编程方式创建SQL数据库 [如何使用ADO.NET和Visual C#.NET以编程方式创建SQL Server数据库 [

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search using your subject as the search term gave these three as the top links:

Create a SQL Server Database Using C#[^]
Create a SQL Database Programmatically[^]
How To Create a SQL Server Database Programmatically by Using ADO.NET and Visual C# .NET[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

这篇关于如何使用C#在sql Server 2005中使用旧数据库创建新数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！