English 中文(简体)
不同服务器的Split数据库
原标题:Split database to different SQL Server

我的英语。

2005年服务器企业数据库。 我写了按日期分列的各档案组所有表格的方案。 但问题是,数据库图形并非为之设计的,大多数信息都停留在<条码>中。

请告诉我,我如何能够将(部分)表格传送到两个或两个以上数据库服务器,以便提高业绩?

最佳回答

你们是否在如何从一个档案组向另一个档案组转移一张桌子? 见http://msdn.microsoft.com/en-us/library/ms19027328v=SQL.90%29.aspx“rel=” ALTER TABLE

ALTER TABLE dbo.MyTable
MOVE TO MyNewFileGroup
问题回答

这对我来说很正确,就像你需要看管服务器的分离能力。 你们不应以人工的方式这样做。 让我们的数据库能够解决这个问题。





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签