Creating dummy copy of database using sharepoint lists (1 Viewer)

treeman

New member
Local time
Today, 05:23
Joined
Nov 11, 2015
Messages
11
So I have a fairly complex database that I've built myself for my business with the backend on sharepoint. It's been working very well but I've added a few things over the past few years, mostly on the frontend but I think I made some changes directly to the sharepoint lists also.

Now I have some functionality that I need added to database that's going to involve heavier coding than I feel comfortable with and I don't have the time that would be involved in mastering it to get these new functions right. My plan is to turn it over to a freelancer to add this new functionality. However, I don't really want to give him all the data or access to the sharepoint site. So what I would like to have happen would be to create a dummy version (basically a copy) of the db and get the sharepoint lists back into this dummy database as tables. I do know where to go to import my existing db into the new dummy copy. However:

  • When I import, do I select definition only?

  • also, there are many tables where I want all the data, for example tblProductName. But there many are other tables, like tblCustomers and tblOrders where I would prefer to not have the data and just insert some dummy data or retain only a handful of records where I can make changes to those few records so that the freelancer has some data to use on figuring out what to do to create what I need.

  • also, of course, the tables that are created from the sharepoint list would have to retain all the relationships that exist now.


If someone could give me a good plan of attack for accomplishing this, it would be much appreciated.

Thanks

Using Access 2013
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 08:23
Joined
Apr 27, 2015
Messages
6,286
i use Sharepoint as a back-end as well and have had to do something similar to what you are describing. What I have done is convert the list the local tables by right-clicking on the list and making the selection. it will copy all records and relationships to a local table with a 1 on the end of the original name...AND...keep your SP list intact.

You can then do as you please with either the local table or SP and then reset everything once you are done...
 

treeman

New member
Local time
Today, 05:23
Joined
Nov 11, 2015
Messages
11
sounds like a plan. Thanks. Hoping it gives me the option of copying with or without data
 

Users who are viewing this thread

Top Bottom