May 7, 2009 at 10:43 am
I originally created a couple of tables in an existing database and tied an Access form to them for data entry. However, I wish I would have created this as its own database. What is the best approach, for a novice, to move the two tables from my existing database and set them up in a new database? Any help will be greatly appreciated.
May 7, 2009 at 10:59 am
Right click on the database in Management Studio, Select All Tasks, Export. Then follow the wizard is probably the best way.
Other option, is connect to database in management studio. Then run a commmand similar to the following which will copy all the data and structure
SELECT *
INTO NewDatabaseName.dbo.TableX
FROM dbo.TableX
May 7, 2009 at 11:18 am
Easy enough. Thank you very much. It is greatly appreciated.
May 7, 2009 at 12:08 pm
I was able to use the DTS wizard to export the data successfully, however it did not copy over the table permissions. How do I copy the table permissions over?
May 7, 2009 at 2:20 pm
You wrote "New Database". What about a backup and restore?
Greets
Flo
May 8, 2009 at 9:12 am
I added the new database to my backup jobs. I scripted the users in and granted the proper permissions to the table. I was just hoping there was an easy way to copy the users and permission over without having to recreate them manually. I got it going though. Thanks for everyone's help. I'm learning.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply