Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2012-04-28 : 03:07:26
|
| dear team,i have an application that uses 5 databases and objects of each datbase is called in other databases. that leads slowness. when we required to insert any record in database "B" from database "A"we need to write a.dbo.tablename then we can insert the records. we cannt make sysnonyms for every objects it also leads in slow nees. now i need to create schemas in one database and these schemas act like databases.please help me that what approach i should use to do that. challenge everything |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-28 : 06:30:02
|
| I don't seem to understand your requirement. Please be a little more elaborate.Are all the databases on the same server??You need to tell us more about the approach otherwise I am not able to make out anything from your post.N 28° 33' 11.93148"E 77° 14' 33.66384" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-28 : 18:57:44
|
| i didnt understand why you chose to put them in separate databases if you're having related data in them and would be always joining on them for getting your data.Latter approach looks better than this. you can use tables in queries by refering them in format schema.tablename if they're all in same db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
pnpsql
Posting Yak Master
246 Posts |
Posted - 2012-04-30 : 02:59:20
|
| our team just converting technology from oracle to sql server, we have not good idea of architecture. we have diffrent schemas in oracle but we dont have knowlede that same there is also schema concept like oracle in sql server. so while migrating databse from oracle to sql server at that time we have created one database for one schema in sql server. now we need to do same in schema level please help.challenge everything |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-30 : 08:12:14
|
| I still didnt understand what your requirement is. But, yes there are schemas in SQL Server. Following are some links that might help you:[url]http://blog.sqlauthority.com/2009/09/07/sql-server-importance-of-database-schemas-in-sql-server/[/url]Creating Schemas[url]http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm[/url]N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 09:45:58
|
quote:
Originally posted by pnpsql
our team just converting technology from oracle to sql server, we have not good idea of architecture. we have diffrent schemas in oracle but we dont have knowlede that same there is also schema concept like oracle in sql server. so while migrating databse from oracle to sql server at that time we have created one database for one schema in sql server. now we need to do same in schema level please help.challenge everything
you can organise them into different schema. But if you dont want to implement different security for them and also data in tables are related, then i would definitely expect them to be put in same schema.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
database and schema