User profile for James Moore

The sqlbackup stored procedure is in the master database. So master..sqlbackup should be used. If you still get this error once you have run it using master..sqlbackup then please let us know. Thanks, - James / comments

The sqlbackup stored procedure is in the master database. So master..sqlbackup should be used. If you still get this error once you have run it using master..sqlbackup then please let us know. Than...

0 votes

Hi there, Your screenshots do indeed look very strange. In the screenshot with the browser showing and no scroll bars the right edge of the window is missing, is there any reason for this or does it just happen as soon as you expand a group bar? For the results screen this also looks very strange - do you definately have all of the columns mapped and included in the comparison (if you generate a script does it update all of the columns or just the ones you can see)? Ctrl-Home, Ctrl-End, Ctrl - -> and Ctrl - <- should allow you to navigate the bottom grid with the keyboard. Could you let me know what version of windows you are running this on and what theme etc you are running? Many thanks, - James -- James Moore Red Gate Software Ltd / comments

Hi there, Your screenshots do indeed look very strange. In the screenshot with the browser showing and no scroll bars the right edge of the window is missing, is there any reason for this or does i...

0 votes

Hi, Could you send me some screen shots of exactly what you see. My email address is james <dot> moore <at> red-gate.com. Many thanks, - James / comments

Hi, Could you send me some screen shots of exactly what you see. My email address is james <dot> moore <at> red-gate.com. Many thanks, - James

0 votes

Joe, You might also want to turn off transactions in the output script (you can do this from project options) as this will allow SQL Server to process your script more efficiently without having to worry about rolling back any changes. - James -- James Moore Red Gate Software Ltd / comments

Joe, You might also want to turn off transactions in the output script (you can do this from project options) as this will allow SQL Server to process your script more efficiently without having to...

0 votes

Hi SQL_Rookie, Data Compare projects work in the following fashion in regards to this - When you select/deselect/map/unmap a table/view this action is recorded in the project then when you try and get the mappings - IE switch to the tables and views tab - these actions are replayed over the set of mappings created to try and generate the same mappings/selections you had previously - if any step of this replaying fails all tables are selected (the default state). This can lead to the incosistency you describe since if you hit select all then deselect half a dozen tables when it replays it will try and do the same thing - IE any tables which were not explicitly deselected will be selected - if the schemas are identical (please check with SQL Compare in case keys are missing etc) - then you should have the same selection made. If the above does not explain the behaviour you are seeing then please let us know. Sorry for any inconvience; we tried to pick the most intuative behaviour for the projects in relation to this but which ever way we went we were always going to get it wrong for a few people. Many thanks, - James -- James Moore Red Gate Software Ltd / comments

Hi SQL_Rookie, Data Compare projects work in the following fashion in regards to this - When you select/deselect/map/unmap a table/view this action is recorded in the project then when you try and ...

0 votes

Please contact support@red-gate.com and they should be able to assist you. - James -- James Moore Red Gate Software Ltd / comments

Please contact support@red-gate.com and they should be able to assist you. - James -- James Moore Red Gate Software Ltd

0 votes

Hi Michelle, 1Tb is theortically no problem for Datacompare, all of our comparison is done on disk etc and thus there is no upper limit to the number of rows allowed other than the availible diskspace (unlike our competitors who have an arbitary limit of the number of rows supported and who do their comparisons in memory leading to out of memory exceptions). As a rule of thumb you need 3-4 times the size of the database free diskspace (This is for a local copy of the data from each database and space for the SQL Script creation) - since this is limiting when doing large datasets as not many machines have 3-4Tb of data we spent a lot of time putting in features to make data comparisons of this size possible by cutting down the amount of data we store or allowing you to compartmentalize your comparison to subsets of a database/table both horizontally and vertically. If you 1Tb databases contain very similar data in both instances then I would suggest looking at the option "Show indentical values in results" under "Comparison Options" on the options tab as this will stop datacompare storing any data which is identical in the two databases allowing the comparison to happen with a much smaller disk space footprint. If your 1Tb databases contain a large amount of different data then I would suggest splitting the table horizontally or vertically and performing the comparisons in parts. You can split the table horizontally by using the "WHERE filter" feature. On the "Tables and Views" tab right click on the tables with a large amount of data in them and choose "Open WHERE clause editor" this will open up a window where you can specify a where clause and split the table into parts. You can also do the equivilent vertically by clicking on the "Columns in Comparison" column next to a table on the "Tables and Views" tab and removing some of the columnns. If you have any further questions then please dont hesitate to post here again or contact sales@red-gate.com with any information about licensing etc. Hope this helps, - James -- James Moore Red Gate Software Ltd / comments

Hi Michelle, 1Tb is theortically no problem for Datacompare, all of our comparison is done on disk etc and thus there is no upper limit to the number of rows allowed other than the availible disksp...

0 votes

You can do this in the following fashion: If we run the command: master..sqlbackup N'-SQL "BACKUP DATABASE [pubs] TO DISK = ''d:\pubs_01.sqb'', DISK = ''D:\pubs_02.sqb''"' You can then run sqb2mtf d:\pubs_01.sqb d:\pubs_01.bak sqb2mtd d:\pubs_02.sqb d:\pubs_02.bak To create the two mtf files, you can then run RESTORE DATABASE [pubs] FROM DISK = 'd:\pubs_01.bak', DISK = 'd:\pubs_02.bak' WITH REPLACE, MOVE 'pubs' TO 'd:\pubs.mdf', MOVE 'pubs_log' TO 'D:\pubs_log.ldf' Hope this helps, - James -- James Moore Red Gate Software Ltd / comments

You can do this in the following fashion: If we run the command: master..sqlbackup N'-SQL "BACKUP DATABASE [pubs] TO DISK = ''d:\pubs_01.sqb'', DISK = ''D:\pubs_02.sqb''"' You can then run sqb2mtf ...

0 votes

Hi Paul, If you need some more time for your trial - so that you can complete your project - then please contact sales@red-gate.com or call them on one of the following numbers: 1 866 733 4283 (toll free USA and Canada) 0800 169 7433 (UK free phone) +44 (0)870 160 0037 (rest of the world) and our sales department should be able to sort out a trial extension license for you. Hope this helps, - James -- James Moore Software Developer Red Gate Software Ltd / comments

Hi Paul, If you need some more time for your trial - so that you can complete your project - then please contact sales@red-gate.com or call them on one of the following numbers: 1 866 733 4283 (tol...

0 votes

As a work around it might be worth having a look at using SQL Compare and SQL Data Compare (you would need to move the DTS packages by hand) - this should allow you to shift the database from SP4 back to SP3a without loss of data. - James -- James Moore Red Gate Software / comments

As a work around it might be worth having a look at using SQL Compare and SQL Data Compare (you would need to move the DTS packages by hand) - this should allow you to shift the database from SP4 b...

0 votes

How can we help you today?

James Moore

Comments