Just backup the database and the encryption key.

Don't lose the encryption key.

There is a scripting tool available if you want to script everything from one server to another. Look on...

http://www.sqlservercentral.com/scripts/source+control/66285/

That's sort of what I was aiming at.

You can populate as many tables as you want with data and just use cartesian joins to give the bulk.

I have reused last...

On other projects that I have worked on, the dev data has occasionally been scrubbed so that names and phone numbers and other account details are gibberish.

Eg John Smith 0406...

Thanks for the feedback Jeff. I appologise to the community for not checking my work more thoroughly.

My next arrticle will be of better quality.

Cheers

Jamie

If you just want the difference between the dates in the two columns

datediff(mm,col1,col2) + 1 to include the first month

eg select datediff(mm,'6/27/13','8/11/13') +1

Cheers

Jamie

😎

I agree we have to view the problem from the clients perspective. Its a skill I pride myself on.

Can I just whinge about the link to the updateable snapshot?

What's wrong...

The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard, but was never used within Transact-SQL.

Jamie Ingram

Hi Gail,

Can partial restores be done with the Dev Version?

Cheers

Jamie

Take a look at extending the security model. There is sample code on MSDN.

http://msdn.microsoft.com/en-us/library/aa237550(v=sql.80).aspx

In particular:

IAuthenticationExtension Represents an authentication extension that can be used to authenticate users in Reporting...

If you just want to run the packages on the new server:

Export your DTS packages using DTSBackup.

Save them to a network location

Create an SSIS job that calls the DTS packages.

Jamie

I dont have access to SQL Server at the moment, so consider this pseudo code. It is untested.

create table #Temp

(

GroupID int;

Col1 varchar2(25),

Col2 varchar2(25)

);

Declare

@Group int,

@Col1...

Fremantle, Western Australia 😎

Try

sqlcmd -Sservername\instancename

😎

You can add the missing text to the file, just make sure that you close of the xml tags correctly.