New Database

  • 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.

  • 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

  • Easy enough. Thank you very much. It is greatly appreciated.

  • 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?

  • You wrote "New Database". What about a backup and restore?

    Greets

    Flo

  • 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