Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,2054,2064,2074,2084,209»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 3:35 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Fal (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to stall to make other people look bad, people who never get back with you...

The backup->copy->restore->check users->update backup software process...

What fun...


We can swap war stories. I'm currently engaged moving all our servers "into the cloud".

Forgive my if I sound a little air-headed and make insubstantial comments.

Fal.

Been there, done that -- I feel your pain. (And the lack of appreciation how much effort it takes, from the managers who read marketing blurbs about "effortless migration.")
Post #1511318
Posted Monday, November 4, 2013 4:00 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
Revenant (11/4/2013)
Greg Edwards-268690 (11/4/2013)
Revenant (11/4/2013)
Jack Corbett (11/4/2013)
Enjoying trying to work with rs.exe to automate some report deployment issues. Especially enjoying the fact that the .rds XML format used when creating data sources in VS/BIDS/SSDTBI 2008 is not compatible with the format used by ReportingServices2010.CreateCatalogItem.
Visual Studio converts them. OTOH, it may force you to fork the project in TFS, if you are using it.


I just love how 2012 uses VS 2010 for lack of BIDS in 2012.
Seems like a bait and switch of sorts.
I wonder what they did in 2014......
You now have 2013, and MSFT promised to keep up with the SQL Server development -- it is now the Servers and Tools division.

If you feel like kicking some asses over there, please let me know.


2014 CPT2, have you loaded it yet?
I like some of the direction in the BI space for features, it just seems they have some disconnects.
For a project type wizard to just more or less disappear, and SSDT goes back to 2010, was just like it was an afterthought. It confused more than a couple developers I'm sure.
Post #1511322
Posted Monday, November 4, 2013 4:22 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Greg Edwards-268690 (11/4/2013)
Revenant (11/4/2013)
Greg Edwards-268690 (11/4/2013)
Revenant (11/4/2013)
Jack Corbett (11/4/2013)
Enjoying trying to work with rs.exe to automate some report deployment issues. Especially enjoying the fact that the .rds XML format used when creating data sources in VS/BIDS/SSDTBI 2008 is not compatible with the format used by ReportingServices2010.CreateCatalogItem.
Visual Studio converts them. OTOH, it may force you to fork the project in TFS, if you are using it.


I just love how 2012 uses VS 2010 for lack of BIDS in 2012.
Seems like a bait and switch of sorts.
I wonder what they did in 2014......
You now have 2013, and MSFT promised to keep up with the SQL Server development -- it is now the Servers and Tools division.

If you feel like kicking some asses over there, please let me know.


2014 CPT2, have you loaded it yet?
I like some of the direction in the BI space for features, it just seems they have some disconnects.
For a project type wizard to just more or less disappear, and SSDT goes back to 2010, was just like it was an afterthought. It confused more than a couple developers I'm sure.

Could you/would you word it as a QA item? Please... thanks.
Post #1511324
Posted Monday, November 4, 2013 6:17 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:22 PM
Points: 857, Visits: 7,456
Fal (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to stall to make other people look bad, people who never get back with you...

The backup->copy->restore->check users->update backup software process...

What fun...


We can swap war stories. I'm currently engaged moving all our servers "into the cloud".

Forgive my if I sound a little air-headed and make insubstantial comments.


Fal.



When I hear managers talking about the cloud idyllically I usually respond "You know what happens to clouds when it rains, right?"


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1511336
Posted Tuesday, November 5, 2013 1:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 35,606, Visits: 32,190
SQLRNNR (11/4/2013)
Ed Wagner (11/4/2013)
SQLRNNR (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to stall to make other people look bad, people who never get back with you...

The backup->copy->restore->check users->update backup software process...

What fun...


I always enjoy the biz stall tactics
I know what you mean. I also love the ever-popular "When I said it should do this, I meant it should do that" syndrome when they didn't think things through to begin with. Fun times...


Fundamental DBA skill - telepathy


... and, high velocity pork-chop launchers.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1511386
Posted Tuesday, November 5, 2013 6:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:55 AM
Points: 1,332, Visits: 19,319
Fal (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to stall to make other people look bad, people who never get back with you...

The backup->copy->restore->check users->update backup software process...

What fun...


We can swap war stories. I'm currently engaged moving all our servers "into the cloud".

Forgive my if I sound a little air-headed and make insubstantial comments.


Fal.

Image in my head of someone tossing servers out the window...


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1511466
Posted Tuesday, November 5, 2013 6:46 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:17 PM
Points: 737, Visits: 5,460
jcrawf02 (11/5/2013)
Fal (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to stall to make other people look bad, people who never get back with you...

The backup->copy->restore->check users->update backup software process...

What fun...


We can swap war stories. I'm currently engaged moving all our servers "into the cloud".

Forgive my if I sound a little air-headed and make insubstantial comments.


Fal.

Image in my head of someone tossing servers out the window...


Hopefully with large helium balloons attached to them, to take them up to "the cloud."

I know I'm going to need to migrate these DBs again in the future, either when we go to Windows Server 2012, or SQL 2012. I'm thinking about dealing with the security requirements (You want a network share? Why? Justify it! No, you need a special dispensation for a service account to have access to it!) and next time setting up log shipping between the old and new servers. Then when the app-owner is ready to pull the trigger, take one last log backup, offline the DB, restore the log backup and recover on the new server and my part is (mostly) done.

On an unrelated note, only about 56 days until I get to go to the NHL Winter Classic!
Post #1511475
Posted Tuesday, November 5, 2013 7:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 10,342, Visits: 13,352
Revenant (11/4/2013)
Jack Corbett (11/4/2013)
Enjoying trying to work with rs.exe to automate some report deployment issues. Especially enjoying the fact that the .rds XML format used when creating data sources in VS/BIDS/SSDTBI 2008 is not compatible with the format used by ReportingServices2010.CreateCatalogItem.
Visual Studio converts them. OTOH, it may force you to fork the project in TFS, if you are using it.


Yup, we are using TFS. It is just a bit frustrating when it is hard to find documentation on it and, in reality, all they needed to do in ReportingServices2010 was support one more XML format. Especially when you consider that they most likely knew that VS/BIDS/SSDTBI didn't support the new format.

I'm ending up writing some VB that parses the rds, creates a DataSourceDefinition, and uses CreateDataSource. I assume that must be what the Deploy process in VS/BIDS/SSDTBI does.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1511494
Posted Tuesday, November 5, 2013 7:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 10,342, Visits: 13,352
Greg Edwards-268690 (11/4/2013)
Revenant (11/4/2013)
Jack Corbett (11/4/2013)
Enjoying trying to work with rs.exe to automate some report deployment issues. Especially enjoying the fact that the .rds XML format used when creating data sources in VS/BIDS/SSDTBI 2008 is not compatible with the format used by ReportingServices2010.CreateCatalogItem.
Visual Studio converts them. OTOH, it may force you to fork the project in TFS, if you are using it.


I just love how 2012 uses VS 2010 for lack of BIDS in 2012.
Seems like a bait and switch of sorts.
I wonder what they did in 2014......


I actually understand that they haven't been totally in sync with versions of VS to do SSRS and SSIS.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1511495
Posted Tuesday, November 5, 2013 8:50 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
Jack Corbett (11/5/2013)
Greg Edwards-268690 (11/4/2013)
Revenant (11/4/2013)
Jack Corbett (11/4/2013)
Enjoying trying to work with rs.exe to automate some report deployment issues. Especially enjoying the fact that the .rds XML format used when creating data sources in VS/BIDS/SSDTBI 2008 is not compatible with the format used by ReportingServices2010.CreateCatalogItem.
Visual Studio converts them. OTOH, it may force you to fork the project in TFS, if you are using it.


I just love how 2012 uses VS 2010 for lack of BIDS in 2012.
Seems like a bait and switch of sorts.
I wonder what they did in 2014......


I actually understand that they haven't been totally in sync with versions of VS to do SSRS and SSIS.


This makes upgrades more difficult than they should be. You spend time going under the covers to figure out what is messed up, then have to make a decision. Create your own hack, or do some rebuilding.
And if we can create a hack, you'd think someone at Microsoft would see the issue and create / publish more information. And maybe some recommendations / tools for mixed environments.

I can understand progress, and not being totally backwards compatible. But as more of these products have become more dependent on each other, it is harder for many shops to upgrade everything at once. For the whole BI stack, you start to include SharePoint and Office, so it becomes pretty broad in an Enterprise. So when you start talking desktops, you've gotten to a whole different level.
Post #1511517
« Prev Topic | Next Topic »

Add to briefcase «««4,2054,2064,2074,2084,209»»»

Permissions Expand / Collapse