populating lookup tables

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

populating lookup tables

Postby noobix » Thu Jul 10, 2008 6:39 pm

Hi,

I'm not sure whether this is the right forum, I didn't know which one to post my question in.

My question is what is the best/recommended practice (using redgate tools) to populate lookup tables in a db?

Tino
noobix
 
Posts: 10
Joined: Tue Jul 01, 2008 2:05 pm

Postby noobix » Fri Jul 11, 2008 6:22 pm

nobody can give me an answer?
noobix
 
Posts: 10
Joined: Tue Jul 01, 2008 2:05 pm

Postby benhall » Fri Jul 11, 2008 11:22 pm

Hello,

Sorry for the delay in replying.

SQL Data Generator is a tool which can generator test data for any sql server database, while your DB\\lookup tables are in development I would strongly recommend using this tool.

http://www.red-gate.com/products/SQL_Da ... /index.htm

For production data, SQL Data Compare allows you to compare and sync the contents of two databases, so if your lookup data is ready in another DB you can easily transfer the data across.

http://www.red-gate.com/products/SQL_Da ... /index.htm

I hope this answers your question, if you need any more particular information please contact myself or the sales team and we will be happy to help.

Regards

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby David Atkinson » Fri Jul 11, 2008 11:27 pm

I product manage SQL Data Compare so I'd be curious for your feedback. Currently you can populate lookup tables in a 'target' database from a 'source' database that you also specify. We are considering allowing the 'source' to be a DML script file (INSERTs) or alternatively a csv or a bcp.exe-type file. Which of these methods would match best what you're looking for? Or is there another way you would like for this to work?

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby noobix » Tue Jul 15, 2008 3:21 pm

Hi David,

a DML script (or more) including many INSERTs is definitely the right solution for us. This is how we populate our DB now.

We'd like a similar feature as in DBGhost Data and Schema Scripter.
This tool can script both the static data and the schema in single SQL scripts.

SQLCompare can do the same but without scripting the static data.
That would be a nice-to-have feature.

Regards,
Tino
noobix
 
Posts: 10
Joined: Tue Jul 01, 2008 2:05 pm

Postby David Atkinson » Wed Sep 02, 2009 12:31 pm

Just to let you know that SQL Data Compare 8 now supports writing out to DML .sql files, and conversely it is possible to synchronize from these DML files back to the database.

This now allows the storage of static data as well as schema in source control.

Regards,

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests