sql-server我应该使用哪个所有者？

i have about 10 scientists writing to a mysql database

我有大约10位科学家写入mysql数据库

i have migrated to sql server and now i have to deal with OWNERS

我已经迁移到sql server,现在我必须处理OWNERS

does it matter which owner i choose? when i do automate migration frmo mysql to sql server it assigns DBO. is that OK? should i continue to use that?

我选择哪个主人有关系吗?当我自动将frmo mysql迁移到sql server时,它会分配DBO。这可以吗?我应该继续使用吗?

so now i have to do:

所以现在我必须这样做:

SELECT TOP 1000 [rid]
      ,[filename]
      ,[qcname]
      ,[compound]
      ,[response]
      ,[isid]
      ,[isidresp]
      ,[finalconc]
      ,[rowid]
  FROM [test].[owner].[calibration]

2 个解决方案

#1

If all of your scientists used all of the tables in your previous database, it would probably be best to stay with DBO. That is the least complicated, and if you don't need the additional schemas, don't make it more complicated.

如果您的所有科学家都使用了以前数据库中的所有表格,那么最好留在DBO中。这是最不复杂的,如果你不需要额外的模式,不要让它变得更复杂。

#2

If you want to use the default owner (really, schema, if you're using SqlServer 2005 or later), you can use the default (which is dbo).

如果要使用默认所有者(实际上是架构,如果您使用的是SqlServer 2005或更高版本),则可以使用默认值(即dbo)。

For more information about the differences between owners and schemas, which are somewhat related, take a look here.

有关所有者和模式之间的差异的更多信息,请参阅此处。

#1