Creating a Monthend Database

Before I moved all the Access Databases to SQL I was able to create a monthend database for each database we had. It wasn't too time consuming as it was a simple copy and paste each month. Now that everything is moved over to SQL I had told the Acctg Dept that I would prefer not to continue with the monthend companies as it is more time consuming to administer. All they use the monthend copies for are for reference if needed throughout the month. When I questioned how much they actually refer back to it, it is not very often. They were quite persistent and old habits are hard to break so I need to find an efficient way of creating the monthend databases and then copying them each month. Does anyone have any suggestions? Your input is great appreciated
Thank
DebI'm going to start with an assumption. What you are
talking about in a monthend database (it means different
things to different people) is a reporting thing that you
transfer to the accounting section.
If thats the case then you may want to consider something
like DTS. You can either run this yourself or create a
job in SQL Agent.
With DTS you can set it up so you do a database query
that exports into say excel, which means you do not have
to cut and paste.
If all else fails however you can go back to how you were
doing it until you get something more concrete.
J
>--Original Message--
>Before I moved all the Access Databases to SQL I was
able to create a monthend database for each database we
had. It wasn't too time consuming as it was a simple
copy and paste each month. Now that everything is moved
over to SQL I had told the Acctg Dept that I would prefer
not to continue with the monthend companies as it is more
time consuming to administer. All they use the monthend
copies for are for reference if needed throughout the
month. When I questioned how much they actually refer
back to it, it is not very often. They were quite
persistent and old habits are hard to break so I need to
find an efficient way of creating the monthend databases
and then copying them each month. Does anyone have any
suggestions? Your input is great appreciated!
>Thanks
>Deb
>.
>|||If your month-end database is simply a snapshot of your operational database
at a specific point in time, you can copy the database to different database
and file names using backup/restore.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Deb" <anonymous@.discussions.microsoft.com> wrote in message
news:982F6016-7AE2-499D-9634-9BE97BA4223B@.microsoft.com...
> Before I moved all the Access Databases to SQL I was able to create a
monthend database for each database we had. It wasn't too time consuming as
it was a simple copy and paste each month. Now that everything is moved
over to SQL I had told the Acctg Dept that I would prefer not to continue
with the monthend companies as it is more time consuming to administer. All
they use the monthend copies for are for reference if needed throughout the
month. When I questioned how much they actually refer back to it, it is not
very often. They were quite persistent and old habits are hard to break so
I need to find an efficient way of creating the monthend databases and then
copying them each month. Does anyone have any suggestions? Your input is
great appreciated!
> Thanks
> Deb