Permission's needed to Migrate Access

[bud31047]

I work at manufacturing plant for a Fortune 500 company. All of the tools I create are used only at my facility. The Corporate Data Security folks are only willing to offer me the following permissions in SQL Server, unless I can demonstrate a "Business Need";

create & drop tables, procedures and view's.

I need to Migrate 20-30 Access97 DB's to SQL Server 2005 Standard and create an intranet website to serve as the front-end to the data.

Since all of the DB's and tools I create are/will not be supported by our corporate tech support, I am concerned that I will get knee deep into this project only to find that I don't have the necessary permissions to finish it. I am relatively new to SQL, so I don't have a good feel for what permissions I would need.

Any help and advice would be appreciated.

 

[bud31047]

Anyone know what SQL Server permissions/privileges would be necessary to migrate/upsize an Access database?

 

[RiverGuy]

I don't know as I've never used the Access upgrade. Is the corporate group going to perform the DBA functions for your database? If so, then you should be able to develop on a copy of SQL Developer Edition--either on your own machine or a development server--so that you have complete control over the server, and then work with the corporate group to attach the database and move your users over to their server.

 

[SQLWilts]

Yup, I agree totally with Riverguy.
You will need SA authority over the server in order to be able to do what you need.
Sounds like you upsize to a local copy of SQL Developer (about £40) and then pass the upsized DBs to your corporate data security guy. He would then take over the role of DBA

 

[bud31047]

Thanks for the information guys. This is what I suspected.