Hi,
I develop in SQL Server as well as MSAS at work. I also have SQL Server
with MSAS loaded on my home PC. Is there a way I can "take" the contents of
the database at work and work on it from home then upload the changes when
I'm back at work? I'm going on vacation and would still like to develop
while I'm out of the office.
Also, is it then possible to export the and then reimport the cubes I've
built as well?
Thanks.
Hello Jason.
you should look at the product I developed after many years of thinking
about database change management. Our web-site also has a white paper on the
subject of automated database change management using your source control
which is the only way (as far as I'm concerned) to guarentee total control
over your source and what is delivered.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Jason" wrote:
> Hi,
> I develop in SQL Server as well as MSAS at work. I also have SQL Server
> with MSAS loaded on my home PC. Is there a way I can "take" the contents of
> the database at work and work on it from home then upload the changes when
> I'm back at work? I'm going on vacation and would still like to develop
> while I'm out of the office.
> Also, is it then possible to export the and then reimport the cubes I've
> built as well?
> Thanks.
>
sql
Showing posts with label loaded. Show all posts
Showing posts with label loaded. Show all posts
Friday, March 23, 2012
Friday, February 24, 2012
Existing project Where do I reset the connection string in the data source?
I closed and opened up my project again - now in the data tab, I get:
The query could not be loaded
Verify your connection string and query string
I have looked and looked - where do I find a menu item with either the Data
Source or the connection string, so I can check it out?On Jan 9, 10:47 am, "Elmo Watson" <s...@.here.com> wrote:
> I closed and opened up my project again - now in the data tab, I get:
> The query could not be loaded
> Verify your connection string and query string
> I have looked and looked - where do I find a menu item with either the Data
> Source or the connection string, so I can check it out?
In BIDS, you will want to open the Solution Explorer (via: Ctrl + Alt
+ L) >> then right-click a Data Source below Shared Data Sources/etc
>> select Open and the Connection string appears there. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That's the problem -
apparently, when I created the report - it wasn't with the wizard, so I
didn't check the 'shared' checkbox.
Is there any way to get to the data source at this point?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:6f710d59-fd4d-49ae-9a12-1abf6df99fa1@.l32g2000hse.googlegroups.com...
> On Jan 9, 10:47 am, "Elmo Watson" <s...@.here.com> wrote:
>> I closed and opened up my project again - now in the data tab, I get:
>> The query could not be loaded
>> Verify your connection string and query string
>> I have looked and looked - where do I find a menu item with either the
>> Data
>> Source or the connection string, so I can check it out?
>
> In BIDS, you will want to open the Solution Explorer (via: Ctrl + Alt
> + L) >> then right-click a Data Source below Shared Data Sources/etc
>> select Open and the Connection string appears there. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||Later, I added a shared data source - created a new report, using that data
source, and now when I open the project and try to run that report, it tries
to access the original (unshared) data source
I'm totally confused now
"Elmo Watson" <sm@.here.com> wrote in message
news:%23VhUK9tUIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I closed and opened up my project again - now in the data tab, I get:
> The query could not be loaded
> Verify your connection string and query string
> I have looked and looked - where do I find a menu item with either the
> Data Source or the connection string, so I can check it out?
>
>|||On Jan 11, 9:15 am, "Elmo Watson" <s...@.here.com> wrote:
> Later, I added a shared data source - created a new report, using that data
> source, and now when I open the project and try to run that report, it tries
> to access the original (unshared) data source
> I'm totally confused now
> "Elmo Watson" <s...@.here.com> wrote in message
> news:%23VhUK9tUIHA.6060@.TK2MSFTNGP05.phx.gbl...
> >I closed and opened up my project again - now in the data tab, I get:
> > The query could not be loaded
> > Verify your connection string and query string
> > I have looked and looked - where do I find a menu item with either the
> > Data Source or the connection string, so I can check it out?
You might try deleting the original data source and then recreate the
report. Also, you could try to open the raw RDL file with a text
editor (i.e., Notepad) and change the <DataSources> tag, etc to the
correct datasource. Hope this helps.
Regards,
Enrique Martinez
Sr. Software consultant
The query could not be loaded
Verify your connection string and query string
I have looked and looked - where do I find a menu item with either the Data
Source or the connection string, so I can check it out?On Jan 9, 10:47 am, "Elmo Watson" <s...@.here.com> wrote:
> I closed and opened up my project again - now in the data tab, I get:
> The query could not be loaded
> Verify your connection string and query string
> I have looked and looked - where do I find a menu item with either the Data
> Source or the connection string, so I can check it out?
In BIDS, you will want to open the Solution Explorer (via: Ctrl + Alt
+ L) >> then right-click a Data Source below Shared Data Sources/etc
>> select Open and the Connection string appears there. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That's the problem -
apparently, when I created the report - it wasn't with the wizard, so I
didn't check the 'shared' checkbox.
Is there any way to get to the data source at this point?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:6f710d59-fd4d-49ae-9a12-1abf6df99fa1@.l32g2000hse.googlegroups.com...
> On Jan 9, 10:47 am, "Elmo Watson" <s...@.here.com> wrote:
>> I closed and opened up my project again - now in the data tab, I get:
>> The query could not be loaded
>> Verify your connection string and query string
>> I have looked and looked - where do I find a menu item with either the
>> Data
>> Source or the connection string, so I can check it out?
>
> In BIDS, you will want to open the Solution Explorer (via: Ctrl + Alt
> + L) >> then right-click a Data Source below Shared Data Sources/etc
>> select Open and the Connection string appears there. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||Later, I added a shared data source - created a new report, using that data
source, and now when I open the project and try to run that report, it tries
to access the original (unshared) data source
I'm totally confused now
"Elmo Watson" <sm@.here.com> wrote in message
news:%23VhUK9tUIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I closed and opened up my project again - now in the data tab, I get:
> The query could not be loaded
> Verify your connection string and query string
> I have looked and looked - where do I find a menu item with either the
> Data Source or the connection string, so I can check it out?
>
>|||On Jan 11, 9:15 am, "Elmo Watson" <s...@.here.com> wrote:
> Later, I added a shared data source - created a new report, using that data
> source, and now when I open the project and try to run that report, it tries
> to access the original (unshared) data source
> I'm totally confused now
> "Elmo Watson" <s...@.here.com> wrote in message
> news:%23VhUK9tUIHA.6060@.TK2MSFTNGP05.phx.gbl...
> >I closed and opened up my project again - now in the data tab, I get:
> > The query could not be loaded
> > Verify your connection string and query string
> > I have looked and looked - where do I find a menu item with either the
> > Data Source or the connection string, so I can check it out?
You might try deleting the original data source and then recreate the
report. Also, you could try to open the raw RDL file with a text
editor (i.e., Notepad) and change the <DataSources> tag, etc to the
correct datasource. Hope this helps.
Regards,
Enrique Martinez
Sr. Software consultant
Subscribe to:
Posts (Atom)