Hi,
I'm working on migrating Access 2002 db's to SQL Server 2005. I am using the "SQL Server Migration Assistant for Access" (SSMA), which seems like a good tool. In the help file for it there is a tantalizing paragraph:
But, no information on how to actually DO this. When I do the migration, all the tables, by default, get loaded into MYDatabase as:
dbo.mytable1
dbo.mytable2
etc.
In the tool I have the option to choose, from a pre-specified list, different "target schema" within MYDatabase, so that some of my tables will load as, for example:
guest.mytable3
db_owner.mytable5
But I actually would like to organize my database, for clarity, into something like the quote above indicates, where I would have something like:
books.mytable1
books.mytable2
audio.mytable3
audio.mytable4
audio.mytable5
video.mytable6
etc.
But How do I change "dbo" to "books"?
I'm working on migrating Access 2002 db's to SQL Server 2005. I am using the "SQL Server Migration Assistant for Access" (SSMA), which seems like a good tool. In the help file for it there is a tantalizing paragraph:
SQL Server databases use the concept of schemas to separate objects within a database into logical groups. For example, a library database could use three schemas named books, audio, and video to separate book, audio, and video objects from each other.
But, no information on how to actually DO this. When I do the migration, all the tables, by default, get loaded into MYDatabase as:
dbo.mytable1
dbo.mytable2
etc.
In the tool I have the option to choose, from a pre-specified list, different "target schema" within MYDatabase, so that some of my tables will load as, for example:
guest.mytable3
db_owner.mytable5
But I actually would like to organize my database, for clarity, into something like the quote above indicates, where I would have something like:
books.mytable1
books.mytable2
audio.mytable3
audio.mytable4
audio.mytable5
video.mytable6
etc.
But How do I change "dbo" to "books"?